Dropdown Default

[Guest]

Hey all,

I'm having a bit of a problem setting a drop down default. I want it to
default based on the value spit out by a query (it's a min function query so
there can only be one value). When I set the default value to the line below,
it just comes up blank. Anyone know how to do this? Can it be done?

=[Default Value]![Expr1]

Thanks in advance!

 

[fredg]

Hey all,

I'm having a bit of a problem setting a drop down default. I want it to
default based on the value spit out by a query (it's a min function query so
there can only be one value). When I set the default value to the line below,
it just comes up blank. Anyone know how to do this? Can it be done?

=[Default Value]![Expr1]

Thanks in advance!

Doesn't the combo box rowsource have values?
What if the query value was not in the drop-down list?

As DefaultValue for the drop-down control, write:

=DLookUp("[Expr1]","TheQueryName")