Open Report Based on Query

[Ofer Cohen]

Change the way you open the report so you can open it from different forms
Use the WhereCriteria of the open report command line, living the
RecordSource without a criteria

Dim MyCriteria As Text
MyCriteria = "[FieldName] = " & Forms!frmCheckAction!TxtSalesID
Docmd.OpenReport "ReportName",,,MyCriteria

From the other form, set a different criteria, or open without a criteria

Docmd.OpenReport "ReportName"

Mybe this link will provide you with a different example

http://www.databasedev.co.uk/report_from_form_record.html

 

[DS]

I have a report based on a Query. In the Query's criteria On one field I
have this
=Forms!frmCheckAction!TxtSalesID
How do I open this report based on this query from a different form? Do I
leave the Query criteria blank? I'm getting confused!
Thanks
DS

 

[TKM]

I have tried this simple step and the report does not even open. Have spent
over an hour and nothing.

DoCmd.OpenReport "rptEmployeeDetails", acViewPreview, , _
"[lngEmpID]=Forms!frmEmployee

Change the way you open the report so you can open it from different forms
Use the WhereCriteria of the open report command line, living the
RecordSource without a criteria

Dim MyCriteria As Text
MyCriteria = "[FieldName] = " & Forms!frmCheckAction!TxtSalesID
Docmd.OpenReport "ReportName",,,MyCriteria

From the other form, set a different criteria, or open without a criteria

Docmd.OpenReport "ReportName"

Mybe this link will provide you with a different example

http://www.databasedev.co.uk/report_from_form_record.html

--
Good Luck
BS"D

I have a report based on a Query. In the Query's criteria On one field I
have this
=Forms!frmCheckAction!TxtSalesID
How do I open this report based on this query from a different form? Do I
leave the Query criteria blank? I'm getting confused!
Thanks
DS

 

[Ofer Cohen]

The path to the feld in the form doesn't include the field name

DoCmd.OpenReport "rptEmployeeDetails", acViewPreview, , _
"[lngEmpID]=Forms!frmEmployee![FieldName]"

Have a look in the link I provided you with in your previous post

http://www.microsoft.com/office/com...ries&mid=b2c61e99-4d2c-469c-a68b-7bfeaa9d58e7

--
Good Luck
BS"D

I have tried this simple step and the report does not even open. Have spent
over an hour and nothing.

DoCmd.OpenReport "rptEmployeeDetails", acViewPreview, , _
"[lngEmpID]=Forms!frmEmployee

Change the way you open the report so you can open it from different forms
Use the WhereCriteria of the open report command line, living the
RecordSource without a criteria

Dim MyCriteria As Text
MyCriteria = "[FieldName] = " & Forms!frmCheckAction!TxtSalesID
Docmd.OpenReport "ReportName",,,MyCriteria

From the other form, set a different criteria, or open without a criteria

Docmd.OpenReport "ReportName"

Mybe this link will provide you with a different example

http://www.databasedev.co.uk/report_from_form_record.html

--
Good Luck
BS"D

I have a report based on a Query. In the Query's criteria On one field I
have this
=Forms!frmCheckAction!TxtSalesID
How do I open this report based on this query from a different form? Do I
leave the Query criteria blank? I'm getting confused!
Thanks
DS