combo box 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?

 

[SkipVought]

hi,

What Application?

What kind of form?

If MS Access, then it would be better to use forum702?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[hpl2001]

Thanks - I will post it over there.