Form, Query in Access

[Vincent]

Hello everyone, I'm pretty new to Access and i have a little situation.

I want to view the Query result from a form

How do I set up the query or form that:

If No Conditions met, display all selected records

if a condition is met, display ALL the record for that condition

thanks a head

 

[Michel Walsh]

Hi,

Assuming the condition is, at the criteria line:


= FORMS!formName!controlName


where FORMS is a key word, formName an open form where the value is to be
read in the mentioned control, then, edit the query in the SQL view, spot:

SELECT ... WHERE fieldName = FORMS!formName!controlName


and change it to


SELECT ... WHERE fieldName = FORMS!formName!controlName OR
FORMS!formName!controlName IS NULL


Hoping it may help,
Vanderghast, Access MVP