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

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

Post by QWNjZXNzIH » Wed, 03 Nov 2004 04:09:04


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.
 
 
 

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

Post by Ken Snell » Wed, 03 Nov 2004 05:17:34

For the criterion expression for that field:

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


--

Ken Snell
<MS ACCESS MVP>

"Access question" <Access XXXX@XXXXX.COM > wrote in

otherwise