specifying criteria in a query from a form

[sheena]

Is it possible to specify the filtering criteria in a query from a form?

 

[Robin]

Hi Sheena,

Yes it certainly is possible to filter a query with values from a form, the form must be open when the query is run.
Just add <Forms.your form name goes here.and the control name goes here> to the criteria line of the field you want to filter. Do not put brackets around it as I have, Access will do that itself.

Regards
Robin.

 

[sheena]

Thankyou