Default Combo Box Based On Default Table Value

Feb 13, 2006

Hi Everyone,

I hope someone can help.

I have a form with a combo boxes and a table with relevant list and additional field, fldDefaultDrive (Yes/No Field).

Currently in order to set the default value, I have used the following code for each default;

Private Sub Form_Load()
Forms!frmMediaLabeller!CboDriveName.DefaultValue = """D"""

End Sub

However, I want users to be able to go into the table and change the default value if thier CD player default Drive is anything but D: Drive. I have tried to replace the D above with an SQL statement but with no success.

Private Sub Form_Load()

Dim Drivename As String

Drivename = SELECT tblMediaDrive.fldDrivename FROM tblMediaDrive WHERE (((tblMediaDrive.fldDefaultDrive)=-1));

Forms!frmMediaLabeller!CboDriveName.DefaultValue = """Drivename"""

End Sub

This is definetly not working, can anybody help, I have a feeling it is syntax but not sure where? :confused:

Robert88

View Replies


ADVERTISEMENT

Default Value For A Combo Box.

Apr 11, 2007

can anyone tell me how i can have the default value of the combo box field as the first value in the combo box drop down list?

View 3 Replies View Related

Combo Box Default Value

Jul 20, 2005

Hi guys,

I'm obviously doing something stupid in my form :-) If you open the form in the attached sample you will see that I have 2 combo boxes. One of them has a default value showing and the other doesnt, I want to get the second combo to automatically show the value in the list but just cant seem to get this to work...

I cant work out whats different bewteen the two. Been tearing my hair out here so would appreciate some input.

Thanks in advance

View 10 Replies View Related

Combo Box Default Value.

Sep 19, 2005

Hi guys,

In my form I have a combo box that is bound to a product/specification table.

When clicked, this combo box displays a list of products, each with its respective set of specifications (although I configured it so just the product column can be seen.) The reason I do this, is so that the specification values (against which certain other values in the form is critiqued) will be a static value in the form itself, and not a changeable value in a table.

What I want to do, however, is to let the combo box assume a default value when the form load (it must already have a product selected at start-up.)

How can I do this?

Thanks ahead!

View 4 Replies View Related

How To Set A Default Value On A Combo Box

Jan 26, 2006

Hi all,

Can some one help me with how to set a default text on a combo box whose record source is set to a query?

I have a form with two combo boxes. The first combo box’s record source is set to the following query:

SELECT chrCategoryID, chrCategoryName
FROM tblGuarCategory;
My 2nd combo box will list all the items based the category I select on the first combo box.

But when the user opens the form, instead of showing both combo boxes blank, I would like to display the following text:

Combo Box1: Select a category
Combo Box2: Select an item…

I tried to use the combo box’s Default Value property like = “Select a category”. It didn’t work. I am not sure what is missing here. I appreciate your help.

View 4 Replies View Related

Combo Box Default Value

Dec 14, 2006

I am sure this is a very basic problem but I just can't seem to make it work...

I have a form with a combo box. The values for the combo come from a table listing available month and year of various data. When the vlaue is selected in the combo box, the form refreshes the data to display that month and updates another table with that month that is used for a few different functions. Everything works great except that when you open the form, there is no value displayed in the combo box. What I would like for it to do is display the month that is equal to the value found in the second table, since that is considered to be the current month. I have tried various approaches to setting the default value and using a query in the control source but It still shows no value when opened. Any advice would be appreciated....

View 2 Replies View Related

Combo Box Default Value

Apr 28, 2006

Hello,

I have a form with a combobox which has its record source to a table which has 5 records.

Is it possible to open the form so that by default the combo shows a specific record?

I have tried something like this but does not work:

On Open event

Me.Cbo = "ID"

ID is the record I need to show.

Thanks.

View 1 Replies View Related

Default Value In A Field Based On A Query

May 31, 2006

Hi,

I have a query which returns 1 value (The description associated with the maximum ID in the table).

I have a Text box on a form and I would like the default value of the text box to be the the value from the above query.

I have tried to build an expression using the expression builder by selecting the query and the field that I am interested in, in that query but I can't seem to get it working.

Could anyone please advise how I can assign a result from a query to the default value of a field on a form.

Many Thanks

View 1 Replies View Related

Combo Box With Variable Default...........

Jul 10, 2005

:confused: I was wondering if somebody can help with my default combo box problem?

I have a secured database whereby users logon, which is used as a scratch pad for keeping track of Purchase orders. A Form frmUserInput with two relevant fields for this problem 1. User Initials txtUsersInitials and 2. POBook (Purchase Order Book) which is the combo box cboPOBooks both unbound fields on the form.

The txtUsersInitials is generated automaitcally when the form is loaded using a VBA statement txtUsersInitials = Current User.

The list of the combo box is generated from a table tbleUsersPOBook and uses a query qryUsersDefaultPOBook as listed below;

SELECT tblUsersPOBook.UsersPOBookName
FROM tblUsersPOBook
WHERE (((tblUsersPOBook.UserName)=[Forms]![frmUserInput]![txtUsersInitials]));

This generates a drop box showing the Different department codes for each individual. So for some it is only one item for others up to three codes, this part works fine... :)

:cool: However here is my problem.

Since some people can sign off more than one Purchase Order book I have had to add an additional field in the table tblUsersPOBook called DefaultUsersPOBook which is a yes/no field, so only one yes exists for each user who logs on. I have created another query qryDefaultPOBook as listed below;

SELECT tblUsersPOBook.UsersPOBookName
FROM tblUsersPOBook
WHERE (((tblUsersPOBook.UserName)=[FORMS]![frmInputForm]![txtUsersInitials]) AND ((tblUsersPOBook.UsersPOBookDefault)=Yes));

When I place this query in the Default section of the combo box it gives me no result.

Firstly is it possible to have a varying default like this since each user will have a different default?

Or is there maybe a better way of achieving a default which is variable for each user based on thier default Purchase order book in the table tblUsersPOBook for the field "Yes" in DefaultUsersPOBook ? :confused:

View 8 Replies View Related

Default Value In Text Or Combo Box

Sep 26, 2005

I am trying to set the result of a query as the default value for a text or combo box. I have tried setting the query as the default value in the box's property. I have also tried doing it in VB. The code looks like this

Dim SQL AS String

SQL = "SELECT Address
FROM Table1
WHERE Name = Forms!Main_frm!name_lbx.Value;"

Forms!Address_frm!address_cbx.DefaultValue = SQL

I have also tried

Dim SQL AS String

SQL = DoCmd.OpenQuery([update address_qry])

Forms!Address_frm!address_cbx.Value = SQL

Where update address_qry is the same as the above.

I keep both forms. I know how to do it by setting the queries as values in a list box, then transfering the values to the text or combo boxes. But I was hoping there was an easier way.

Thanks
Alex

View 1 Replies View Related

Default Value In Text Or Combo Box

Sep 26, 2005

I am trying to set the result of a query as the default value for a text or combo box. I have tried setting the query as the default value in the box's property. I have also tried doing it in VB. The code looks like this

Dim SQL AS String

SQL = "SELECT Address
FROM Table1
WHERE Name = Forms!Main_frm!name_lbx.Value;"

Forms!Address_frm!address_cbx.DefaultValue = SQL

I have also tried

Dim SQL AS String

SQL = DoCmd.OpenQuery([update address_qry])

Forms!Address_frm!address_cbx.Value = SQL
Where update address_qry is the same as the above.

I keep both forms open. I know how to do it by setting the queries as values in a list box, then transfering the values to the text or combo boxes. But I was hoping there was an easier way.

Thanks
Alex

View 2 Replies View Related

Set A Default Choice In A Combo Box

Jun 14, 2006

I used a combo box to let user select "Proejct Status" such as active, completed, cancled. I want to set active as a default selection if user does not choose other status. How can I do that? Thank you very much for your help.

View 2 Replies View Related

Default Value In A Combo Box From A Query

Nov 5, 2006

Hi all,
New to the board and access (2000)

I have been tasked w/ creating a database to schedule and track incoming cases for my job (Dental Lab)

This entire thing is new to me but have developed most of it through reading this forum so thanks for that!
I still have a long way to go...

Here is what I am stuck on -
I have a table of technicians
here you can add the first name, last name, and department (The department is coming from another table called department)

These are working fine,

Now I have a table for the doctors to fill out a form to initiate a new case,
In this table I have a field called techassigned1 which pulls from a query of the technician table where the deptmant is set to plaster bench.

This works fine - I get a dropdown box with the technicians name that is assigned to the plaster bench (This name changes periodically)

But All I want is for that 1 name to be set as a default value - I need it in the table so I know who started the work on the case
I dont want the doctor to have to choose this name

I read in the forum and used
Me!techassign1.DefaultValue = Me!techassign1.ItemData(0)
in the forms ONOpen event

But this is what happens
The form just displays #Name? in the dropdown box but the correct name is under it if I click the arrow
But if I right click and look at the property sheet the name is in the default value property but it still doesnt update the techassign1 field in the table.

Is there a way to have this automatically add the technician from the query to the table? without haveing to select it?

Any help is greatly appreciated -
If I am not making sense plese let me know and I will try to explain it better.

View 7 Replies View Related

Combo Box - Default Typing

Nov 30, 2005

Hi all...I have a combo drop down box that has the 50 states in it. I would like the list to pop to the first state that starts with a letter typed in. For exampe, you type 'C', takes you right to CA.

Anyone now how to do this? (silly question )

View 2 Replies View Related

Combo Box Defaults Without A Default Set

Jan 10, 2006

I have combo boxes that have all been created using the wizard with the options Yes, No and Not Applicable. There is no default set but they default to the second entered option ("No") every time. I have created the form a second time in the hope this would do something but to no avail. Any ideas??

View 1 Replies View Related

General :: Combo Box Default Value

Apr 9, 2014

I got a COMBO BOX with 2 columns , for instance code and name.

CODE NAME
123 JOHN
124 JACK
125 BILLY
126 MARY

In the OPEN form action which the form using this combo to do some query action, I want to put a default value to this combo box after a VBA query result of which should return a name to this form. Just want to know how to put the result to this combo box, e.g. when the VBA query return a name Billy. What's the syntax to make this combo box equal to Billy and do corresponding query?? Thans a lot!! FOr the time being I just know the following syntax, but since the combo box got 2 columns and how can I know Billy is located in the third record?

Me.Combo24.DefaultValue = "FORMS![Master]![combo24].itemdata(0)"

View 1 Replies View Related

Default Display On Combo Boxes

Aug 24, 2005

Is there a way to force a combo box to display the first value in the list as its default value?

To be more specific the combo box needs to display this value when the parent form is opened or when you use VBA to change or add the row source.

When ever I use a saved query as the row source the default value is always Null.

Thanks Everyone,
Joe

View 3 Replies View Related

Assign Last Record In Combo As Default Value

Mar 3, 2006

Me!ComboName.DefaultValue = Me!ComboName.ItemData(0)


this assigns the first value in the combo box to the default.

can this be changed to always assign the last possible record in the list as the default.

View 2 Replies View Related

Setting Combo Box Default Selected Value

Aug 21, 2006

i have a combo box on my form that uses UNION query to put "<select>" as part of the list items.right now "<select>" appears on top of the list but what i mtrying to do is when the form loads i want the combo box to have "<select>" selected and not just show blank unless someone click on the down arrow. i m sure there is a way/propoerty to do it but i cant figure it out. Also how can i make my combo box so user cant type in a combo box but select from the list.

View 2 Replies View Related

Forms :: Combo Box Default Value Property

May 22, 2013

I have a combo box that takes it's data from a table called tblFruitBasket. What code do I put in the Default Value property such that the default value is the fifth element (or say fifth row) of field [Fruit] of table tblFruitBasket?

View 2 Replies View Related

Modules & VBA :: Default Combo Box Value After Requery

Oct 2, 2013

I have this code:
If Me.OpenArgs = "frmAddChecklist" Then
Set ctlCombo = Forms!frmAddChecklist!cbDEPARTMENT
ctlCombo.Requery
End if

And this code is done after I added new value to table, and now I want that new value to be used as default one, how can this be done?

View 1 Replies View Related

Using Combo Boxe Instead Of Default Record Navigators

Jan 26, 2006

I have built an example of a form that I am working on. My original design used the default record navigator bars that are setup when you use the wizard to create the form. I would like to remove those bars and use the linked combo boxes that I have placed onto the form instead.

My end all goal is to have those two record navigation bars completely gone from the form and have the combo boxes perform the same function they were used for.

I would like to keep the data entry portion of the form the same because I like the design and I like that I can limit it to data entry only so theres no chance that the users will accidentally modify existing data. However, if you have a different method of entering the data that will still provide me with the protection of "data entry only" that will be welcomed.

View 12 Replies View Related

Problems Referring To Combo Box For Default Value In Subform

Nov 30, 2006

I want my subform to allow additions. I would like the default value for one of the fields in the subform to be the value chosen in the combo box that is used to select which records are shown in the subform. The row source for the combo box is

SELECT tblLicensee.LicenseeID, tblLicensee.[Licens#] FROM tblLicensee;
where LicenseeID is the key field and Licens# is what is displayed.

If I refer to the combo box for the default value for that control on the form…
=[Forms]![frmFindRecord]![Combo37]

the key value (LicenseeID) is entered as the default instead of the value displayed in the combo box (Licens#). How can I set the default value to record the Licens# instead?

View 1 Replies View Related

General :: Using A Combo Box To Set Default Value For Subsequent Records?

Nov 29, 2012

I am trying to create a user friendly form to enter a list of competitors entering an event.

I would like the user to pick from a list of events and that event to be used for subsequent records until the user changes it.

I have used a combo box to pick from a list of events but that needs to re-selected for every new record. I then added a second unbound combo box to give the main combo box its default value. It works but is not very user friendly.

View 4 Replies View Related

Setting Text Box Default Value Based On Query Version: 2000 (9.0)

May 19, 2005

I am creating a database that should be fairly simple. The database is for a local racetrack and I'm stuck on how to entering race results. I have four tables: Driver, Rank, Home, Class. The form to enter in the results contains a main form with a subform. On the main form there are two combo boxes, one to select the Class of the race, and one to select the Heat of the race: i.e Finals, 1, 2, 3. The subform currently has a text box containing the rank of the driver for that race and the driver's name. I want the Rank to automatically start at one and increase by one each time a new driver is added. The rank field is part of the primary key but cannot be an autonumber field because there will be multiple ranks in the rank table. The rank table contains a primary key of: Class_ID, Rank, Heat. Therefore, each class/heat combo needs to start at 1 and increase. I created a query that finds the max rank value of the class/heat combo and I thought I could use that value +1 for the default value of the Rank field but I'm not having any luck. I have attached the database so that you can see what I all have as there isn't any sensitive information. If it would be easier doing it some other way than using the query that is fine to. I'm open to anything that works. I also want the Driver combo box in the Rank form to be limited to only contain drivers whose Class_ID matches that of the selected class in the main form. I have the row source set up sot that it works when I make my first selection when entering the form but not when I change the selected class and I do have an After_Update event set for requerying. It seems this should be so simple but I'm just missing something. Thanks in advance for your help!

View 1 Replies View Related

Tables :: How To Get Combo Box In Header To Be Default Object Selected

Oct 21, 2014

I have a request from users to have a combo box in the form header defaulted to the selected object when they open the form or search on a new person (same object they want to be default). Currently it defaults to the first box in the detail section. (I hope this makes sense)

I believe I can do it with events, just wanted to know if there is a different way.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved