Multiple Reports from Form

[MoeOneill2002]

Hi,

I have an invoice tracking database. I have created a form that has 16 preview report buttons, 8 of these are for overall totals and these work fine, the other 8 are for monthly totals by company.

I have set the form to have the user input Start & End Dates (Unbound text boxes), I want to be able to enter the dates once for the 8 monthly reports and the user can click the report button. If I have the query criteria set to between[start date] and [end date] the form asks for the dates once the user presses the button even though it is entered on the form already.

Any help is greatly appreciated.

Thank you
Maureen

 

[pdldavis]

Hi - a couple suggestions.
1. Ensure you are not closing your form when you print your report. If this is happening, the report will be looking for your start & end dates and won't find them because the form is closed.
2. Ensure the report's control source includes a statement in the date criteria similar to:
<Between forms!frmMainMenu.txtDateStart and forms!frmMainmenu.textDateEnd> , which can easily be created using the expression builder.
3. Ensure your date fields are formatted for date values.
Hope that helps.

 

[MoeOneill2002]

Thank you the second one works like a CHARM!!!!

Maureen