How to get the info from form to query to report

  • Thread starter Thread starter sandyL
  • Start date Start date
S

sandyL

I have a form that uses 5 tables for the information so I built a query to
have the info all in one place. I also want to use the submit button to send
the information to a report to be emailed, right now the report comes in
blank. Please help I am fairly new to access and trying to build this for
work.
 
Base you report on a query.
Use the form reference as criteria in the query like this ---
[Forms]![YourFormName]![YourObject]

[YourObject] is displaying the data from the 5 tables.
 
Back
Top