G
Guest
In Form I put a button that was wizard to open a Report.
I went into build event for that button and at the DoCmd added a WHERE
condition
was:
DoCmd ReportName, acViewPreview
I changed to:
DoCmd ReportName, acViewPreview, ,"ReportID=" & Me.BillingID
so that the value of textbox (BillingID) of this form is the criteria for
the report to open onto the record that has that same value in it's ReportID
field (based on the equivalent table field)
and it works - except - before the report opens I get a message box prompt
to Enter Parameter and the value of BillingID is showing in the
message box prompt - - - it really looks identical to a standard Parameter
Query message....
I went into build event for that button and at the DoCmd added a WHERE
condition
was:
DoCmd ReportName, acViewPreview
I changed to:
DoCmd ReportName, acViewPreview, ,"ReportID=" & Me.BillingID
so that the value of textbox (BillingID) of this form is the criteria for
the report to open onto the record that has that same value in it's ReportID
field (based on the equivalent table field)
and it works - except - before the report opens I get a message box prompt
to Enter Parameter and the value of BillingID is showing in the
message box prompt - - - it really looks identical to a standard Parameter
Query message....