View Full Version : specifying criteria in a query from a form


sheena
09-26-2000, 01:52 AM
Is it possible to specify the filtering criteria in a query from a form?

Robin
09-26-2000, 02:15 AM
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
09-26-2000, 03:03 AM
Thankyou