Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

filtering queries based on input to a form!

Status
Not open for further replies.

dara

Technical User
Apr 24, 2001
6
GB
Hi,
I can get a form to run a report and i can get a report to run queries. But i can't put them together and filter the queries depending on input from the form.
e.g. form calls -> report calls -> query

Any ideas would be helpful!
 
Dara,

You need to refer to the form field, by which you wish to filter by, in the criteria section of your query as such:

Like [forms]![formname]![formfieldname]

Best regards,

Henr¥


 
thanks henry i'll have a look
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top