How I will set criterian for combo boxes??

[Ramshan]

Hi,

I am wondering how one will set criterian for combo boxes?
that is for text boxes we use this, where qprop is the text box. If county is in a combo box what the criterian would be?

Like [Forms]![SearchForm].[qprop1] & "*"


Thanks!

 

[John Big Booty]

For a combo you can simply use;

[Forms]![FormName]![ComboName]

Remember though that this will return the bound column of the combo box.
If you want to match on what is being displayed in the combo, use;

[Forms]![FormName]![ComboName].[Text]

 

[John Big Booty]

...the above assumes that the combo has it's Limit to list property set to True.