Dialogue date input form for a report query

[aymanmb]

Hi,

I am trying to have my report generated based on a date range as per the northwind databse example.

I did everything exactly as per the example:
a dialogue form to input the date range
copied all codes and modified it with me control names in OnOpen, OnClose and OnNoData events of the report
copied the necssary module (utility Functions) from northwind databse

OK, I try to open the report, the dialogue form opens (so fa so good), I input the dates and click OK, oops the error message "To Oopen this form you must preview or print your report from databse window or design view"

As far as I can figure, the code in the OnOpen event should be doing something to tell that the report is open for the dialogue form to input date and I think here I am missing something because the above message will display only if the report is not open as per the rest of thecode in the OnOpen event.

can someone help

thanks

 

[Dennisk]

your sequence of events may be wrong.

1) open form
2) enter criteria
3) click print button - the code in here is where the report is opened.