Filter criteria using list boxes on a form

  • Thread starter Thread starter JB63
  • Start date Start date
J

JB63

If I use several list boxes on a form to filter the data displayed on a
subform using the subform's "record source" SQL statement, how can I have the
query return all of the data if nothing is selected in the list box. as of
now no records are shown if one of the list boxes is empty. Thanks for any
help.
 
Use the list boxes as criteria in a query that feeds the subform.
Criteria would be like --
Like [Form]![YourFormName]![Listbox1] & "*"
and to include those that are null use --
Like [Form]![YourFormName]![Listbox1] & "*" Or Is Null
 
Back
Top