Parameter for subform record source

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have a report in an Access 97 database where I want to
limit whether or not subreport records print based on a
date field. However this date criteria will change. So I
set a popup parameter box for the query that is the record
source for the subreport. The problem is that when the
Parent report is opened the subreport Parameter box fires
not just once. It fires once for every detail record in
the Parent report. How do I set it up so that the
Parameter box only appears once?

Thanks if you have an answer!

Mark
Ontario, Canada
 
Use text boxes on a form to enter your parameters. Your criteria would then
be something like:
Forms!frmYouForm!txtYourTextBox
 
Back
Top