Credit form in front of a report (Access 2002, Win 98 2nd R)

Topic

New Reply

I was wondering how to put a form in front of a report so that people with no experience has an easier time of using the program.

The other question regards a report with two subreports. both sub forms have 3 parameters each. The parameters are the same on both subreports. How can I fix it so that I have to input the data only once?

Thank you for your time and responses. Fay

Reply | Quote

Replies

You can create a criteria form that will have fields for all the parameters needed. So let’s say you need a start date and end date; put those two textboxes on a form frmDateCriteria; add an “OK” button, cmdOK; in cmdOK click event make the form invisible. In the open event of your report, add code to open frmDateCriteria. When users fill in the parameters and click OK, the report will run. In the close event of the report, close the criteria form. You will also want to change the queries behind your subreports to pull values from the form, so instead of [Enter Start Date] in the criteria, use Forms!frmDateCriteria!txtStartDate.

Reply | Quote

If the subreports are properly linked to the report, you shouldn’t need parameters on them because their recordsets will be filtered by the parent report. If you’re using unbound subreports, that is subreports not linked to the parent report, then you’ll have to do it as Dottie suggests.

Credit form? What exactly do you mean by that? Are you talking about a switchboard/menu form?

Reply | Quote