In MS Access, I have a query, linked to a table, calculating stuff based on infomation in the table and I have a report. The report is an invoice which shows all the fields in the query in report form, but shows it for every record, one on each page.
In a form I created, when I want to print the invoice for the record I am viewing (the form is linked to the same query the report is linked to) it prints the entire report.
Now, I'm guessing there must be some way of making the button to print the invoice to print just the invoice for the record I am viewing in the order form, or at least let me specify. I'm pretty sure it has something to do with criteria in a query, but in this case I have no idea how to manipulate it.
In a form I created, when I want to print the invoice for the record I am viewing (the form is linked to the same query the report is linked to) it prints the entire report.
Now, I'm guessing there must be some way of making the button to print the invoice to print just the invoice for the record I am viewing in the order form, or at least let me specify. I'm pretty sure it has something to do with criteria in a query, but in this case I have no idea how to manipulate it.
