Print Invoices within a range of dates

[franksirvent]

I have search on the forum for a while but I have not been able to find a solution to my problem

I have a db which issues invoices.
Form and subform format.
A button makes it print.
So far so good. This works fine.

Now I have created a form which you input 'date from' and 'date to' and presses a button to make ALL invoices within that date rage to print.

However what I get is a long report, with wrong data.

I need the report to simply be the same as when I print the invoice one by one.

I am changing the report query to be 'all records which date match the two dates' but that's obviously not enough as it is not coming up correctly

Any ideas ?

 

[dhookom]

I expect we might need to see how you are using the date from and date to on the form you created. We can't see you values or your report or your record source query or your code or anything else.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]