More reporting hell for a novice

[KNap]

I posted a question on here a couple of weeks ago - and I muddled my way through to find the information, count it and put it on the form in a list box.

I now have the issue of being asked three times for the date parameters for the report - is there any way I can reduce this to being asked once?

Thanks in advance
Kelly

[Welshgasman]

Use Tempvar for the date

[Gicu]

You should not use prompts in the queries (i.e. [Enter Start Date:]) feeding your report\subreport but add two textboxes to your form (on which you have the button to open the report) for your start and end dates then reference those in the query: Forms!frmYOUR_FORM!StartDate (where StartDate is the name of the unbound textbox control where you'll enter the start date).
This way you will not get any prompts. Note that you will want to add some validation before attempting to open the report by checking if both textboxes have valid values.
Cheers,

[KNap]

Sorry - I'm self taught and have no idea what that means?

[Micron]

Are you opening the report by use of the form (e.g. there is a button on the form for this) or are you opening it from the nav pane where all the query/table/report objects might be listed? You should be using a form to do what Vlad suggests. On the form:
- add 2 textboxes; one for FROM date and one for TO date. If on the forms property sheet, Format tab you set the Format to Date you can make use of the date picker for these 2 controls
- your form also has a button for opening this, and I suppose any other report that might be listed on it
- your button code should check that there is a value in each box, that the values are dates, and that FROM is not later than TO.

Let us know when you get that far, and post the names of your date controls.