Opening a report from a form.

A

Angel b1

I would like to open a report and restrict its records to those
Specified by the value in a text box on the form. The report is based on
A query. The criteria in the query is blank. I don’t what to be prompted by
The where condition in my code. Does anyone know how to do that?

strFilter = "qry_selectMemberRequest"
DoCmd.OpenReport "rpt_SelectMemberRequest", acViewPreview, strFilter,
"tbl_memberOverrides.memberID=txtmemberID"
 
M

Marshall Barton

Angel said:
I would like to open a report and restrict its records to those
Specified by the value in a text box on the form. The report is based on
A query. The criteria in the query is blank. I don’t what to be prompted by
The where condition in my code. Does anyone know how to do that?

strFilter = "qry_selectMemberRequest"
DoCmd.OpenReport "rpt_SelectMemberRequest", acViewPreview, strFilter,
"tbl_memberOverrides.memberID=txtmemberID"
Click to expand...


Please don't multi post your questions.

I tried to answer this one in another newsgroup.
 
Top