swtichboard, dates and mutliple reports

  • Thread starter Thread starter cporter
  • Start date Start date
C

cporter

I have several reports that ask for a set of dates and have a form for
this. Right now on the switchboard the button opens the report and the
date form opens due to the on open event property of the report. The
form has default values that allows this to work. How can I open the
date form through the switchboard and then open the required report
after the date form is populated?
 
Have the Switchboard open the form and put a button on the form that opens
the report with criteria setting the fields on the report to those on the
form, e.g.
fieldonreport = Forms.[form'sname].[fieldname]
or make the source for the field(s) on the report the field(s) the field(s)
on the form e.g.
Forms.[form'sname].[fieldname]
Note, don't close the form until after you open the report.
 
If I understand right, doing it that way basically binds the
form/button combo to one report. The idea is to has one form and one
button for many reports, if possible.

Basically I want to use an unbound to populate the date fields in many
reports. I'm doing that now with the default data but I need to get the
correct data in first then open the report.
 
If I understand right, doing it that way basically binds the
form/button combo to one report. The idea is to has one form and one
button for many reports, if possible.
Click to expand...

The combo isn't bound to the report, the report simply grabs the value from
the combo.
Basically I want to use an unbound to populate the date fields in many
reports. I'm doing that now with the default data but I need to get the
correct data in first then open the report.
Click to expand...

Your last sentence is correct. You enter the date in an unbound field in the
form and then transfer that value to your report(s). You can have as many
buttons on the form that open different reports and each report can "get" the
value. However, if you are going to run multiple repotrs each time you might
want to use code or a macro to run them from one button.
 
Back
Top