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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtered Records in Form to Report

Status
Not open for further replies.

pgar

MIS
Aug 10, 2006
3
GB
Hi,
I am using Access 2003. I have created an Entry and Query Form with Sub Forms. Can we generate a report from the Query(Filter) made on the Form.

Please help.
Thanks
 
Hello
You can set the record source of a report to the record source of a form and the report filters to the form filters.
You can build report criteria from a form:
Build Report Criteria via a Form w/list box, text box, date range, faq181-5497
And you can open a report with a Where statement.

Which is nearest to what you want to do?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top