Problem filtering specific record from form to report

  • Thread starter Thread starter Chris Howe
  • Start date Start date
C

Chris Howe

In Access 97, I want to print a report that will filter
the record based on a control on a form (with a subform).
I put the print button on the subform and tried to pass
the primary key id to the report but I get the parameter
dialog box. I don't want to be prompted for the id, rather
the id is passed from the form to the report.

The report has a query attached that asks for the
parameter. The form contains a control called status_id
that I am trying to pass. I tried attaching a "openreport"
macro to a button with a where clause and that did not
work. I got a dialog box prompted twice, one from the
macro and the other from the query.

How can I pass the parameter without getting the parameter
input dialog. Thanks.
 
In your query set the criterion to [yourform].[status_id]
make sure that the text box on your form is named
status_id .
Hope this helps.
Fons
 
Back
Top