setting default value for access 2000 combo box

  • Thread starter Thread starter merkel
  • Start date Start date
M

merkel

I created a combo box that references a table. How do I
set the form to automatically select the first value in
the combo box. I have tried varous things but nothing
seems to work. I keep having to use the drop down arrow to
select a value.

In the Default field of the Data tab on the toolbox, I can
set the following:

[Country_tbl]![Country]=[Country_tbl]![Country]

My table name is Country_tbl and my column name is
Country, but how do I specify the first row value, which
in this case is CA.
 
My table name is Country_tbl and my column name is
Country, but how do I specify the first row value, which
in this case is CA.
Click to expand...

Two suggestions:

- Change the Name property of the combo, say to cboCountry. Access
can't tell whether you mean the name of the control or the name of the
field.

- Set the combo box's Default Value property to

"CA"

or if the bound column is actually a numeric key, to the desired value
of that key.
 
Back
Top