I have a Form which shows a bunch of client personal info, and
1. fees a client pays, and
2. a calculated value which shows the sum of fees + taxes.
I've created a report which also shows the fees for every client, to be an invoice report. Now, on the original Form, I want to be able to hit a "Print Invoice" button, which will automatically open and print the invoice report.
The problem I'm having now is how do I get Access to print the invoice report for ONLY the current record (one client) of the form? It's printing every single client right now when i click the button, which equates to about 100 pages of invoices.
Please help. I've tried searching, and have tried some basic SQL, but no luck. Thanks.
1. fees a client pays, and
2. a calculated value which shows the sum of fees + taxes.
I've created a report which also shows the fees for every client, to be an invoice report. Now, on the original Form, I want to be able to hit a "Print Invoice" button, which will automatically open and print the invoice report.
The problem I'm having now is how do I get Access to print the invoice report for ONLY the current record (one client) of the form? It's printing every single client right now when i click the button, which equates to about 100 pages of invoices.
Please help. I've tried searching, and have tried some basic SQL, but no luck. Thanks.
Thanks Pat.
