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

  • Thread starter Access question
  • Start date
A

Access question

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.
 
K

Ken Snell [MVP]

For the criterion expression for that field:

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