I want too use a combox to fill in the criteria off a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want too use a combox to fill in the criteria off a query and when the
combobox is empty I want to find every result. How can I make this possible?
 
Write the criteria expression this way:

[Forms]![FormName]![ComboboxName] Or [Forms]![FormName]![ComboboxName] Is
Null

--

Ken Snell
<MS ACCESS MVP>

paul said:
I want too use a combox to fill in the criteria off a query and when the
combobox is empty I want to find every result. How can I make this
possible?
 
Back
Top