ComboBox Default Issue

[hpl2001]

Hi:

I have a combo box on my form that is bound to a Facility table, i.e. the row source is the table "Facility Lookup". This table lists all the available facilities. I want my box to default to the facility name that is found in a query (qryBoxfilter).

In my combo box porperties I have set this as my control source:

=[qryBoxFilter]![Facility]

I have also set this as my Default Value:
=[qryBoxFilter]![Facility]


My form is opening with nothing showing by default in the combobox, although the box itself is will drop down with the correct list. How so I get my query value to show as the starting value in my combo box

 

[dhookom]

I would try either a default of:
=DLookup("Facility","qryBoxFilter")
Or possibly use code in the On Open of the form to set the value or default value.

Duane
Hook'D on Access
MS Access MVP