Querying on Forms

[Guest_imported]

I have a problem in Access query (SQL) which use fields from the Forms that are a part of my database. I have various forms which have some common fields and values of most of them are based on a query.

In the query, while mentioning the form name, Me!field_name
does not work, and i have to write Form_name!field_name which means A DIFFERENT QUERY FORM EVERY FORM, inspite of the fact that same logic is being used for all the form fields.

Can I get away with this? How??

 

[JoeMiller]

Can't get away with it, you have to specify using [Forms]![MyFormName]![MyControlName]. You may want to look into the QueryDef function which allows you to modify a query through code, then you could change the criteria on an as needed basis.

HTH Joe Miller
joe.miller@flotech.net