selecting rows

maravinds

Registered User.
Local time
Yesterday, 16:20
Joined
Apr 26, 2006
Messages
26
Hallo Everyone,

I have a small problem in query selection. I have a query that selects values based on a criteria. [value from a combobox]. The problem is that i need to select all the rows if the value of the combobox is empty.





aravind.s
 
Try this in criteria:

Like [Forms]![FormName]![ComboName] & "*"
 

Users who are viewing this thread

Back
Top Bottom