Help linking a report to a form

[SColbert]

I've got a report set up as a quote that when complete, is e-mailed to a customer. The report contains data entered on a Quote Entry Form. I have a button set up on the form that opens the Report when clicked. The report can then be "printed" in Adobe Acrobat saving it as a PDF file that is then e-mailed to the customer.

Right now, the user has to enter the Quote information in the Quote Entry Form, then enter the Quote Number after pressing the Print Report button. Is there a way to automatically populate the report with data from the most recently entered record in the Quote Entry Form when the Print Quote button is clicked?

 

[nrugado]

Yes, Go to the query builder for the report, right click on the column named quotenumber and the row named criteria, select build.

Expression builder will open up and you are basically going to tell the query where to look for the quote number. Since you said that the quote number is on the form that the user is entering you can reference the report's query to use that field's contents as criteria for the report. Hope that helped let me know if you need more.
Nick

 

[SColbert]

Yes, right now I've got [Enter Quote # to Print] in that field of the query which pops up a window that requires user input. What is the correct expression to use in that criteria cell that will populate the report with the current form's data?

 

[nrugado]

Replace that with this....

[Forms]![FRM_PAF_Main]![Combo80]

[forms]![the name of your form]![the name of your listbox,cbo box or text field]

That goes in your qry and it will look toward that for criteria.

Good luck