display data (from query) on an access form using 3 different inp.

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

Guest

I am creating a form that has three parameters. It is based on a query. On
the form I am allowing the user to select up to 3 different parameters. If
the parameter is blank, I would like to have the entire list shown, otherwise
select from the form.
 
For the criterion expression for that field:

Forms!FormName!ControlName Or Forms!FormName!ControlName Is Null
 
Back
Top