I followed a tutorial online that helped me add a query to create a preview report button so that i can print a receipt from a student invoice.
The report runs fine, as long as I enter the invoice ID #. I want to bypass that step and have the query and report (they are linked together?) open for the current record only.
The current query criteria is: [Forms]![Invoice]![InvoiceID]
This database is for student registration.
I have an invoice form with a subform that totals beautifully.
When I enter the invoice id, the report previews and I can print from there.
I simply want to have the command button open the current record to show the preview of the receipt to print.
I have student data inside the database, but if the file is needed, I can create a copy and remove student data.
I have searched online and someone mentioned a crosstab query, but my eyes are crossed trying to figure this out. Thanks in advance.