Open a Report with two different forms

[Eric]

I have a report (rptRepairRequest) that I have command button that
prints it out from a form based on the ID of that form. This works
fine. What I would like, and not sure if it is possible, is to have
another form where I can just select the ID from a drop-down and open
the same report.

My record source for the report is currently:
SELECT tblRepairList.* FROM tblRepairList WHERE
(((tblRepairList.RepairID)=Forms!frmSerReqEntry!txtRepairID));

I tried adding an OR statement at the end:
"OR (tblRepairList.RepairID)=Forms![frmRptRepairRequest]!
[cboRepairID]"
but it asks me for 'Forms!frmSerReqEntry!txtRepairID'

Are is there anyway to make this work, without making a new report?

 

[Marshall Barton]

I have a report (rptRepairRequest) that I have command button that
prints it out from a form based on the ID of that form. This works
fine. What I would like, and not sure if it is possible, is to have
another form where I can just select the ID from a drop-down and open
the same report.

My record source for the report is currently:
SELECT tblRepairList.* FROM tblRepairList WHERE
(((tblRepairList.RepairID)=Forms!frmSerReqEntry!txtRepairID));

I tried adding an OR statement at the end:
"OR (tblRepairList.RepairID)=Forms![frmRptRepairRequest]!
[cboRepairID]"
but it asks me for 'Forms!frmSerReqEntry!txtRepairID'

Are is there anyway to make this work, without making a new report?

Remove the criteria from the query.

Instead use the button code to use the OpenReport's
WhereCondition argument:

DoCmd.OpenReport "report name", _
WhereCondition:= "RepairID=" & Me!txtRepairID

 

[Eric]

I have a report (rptRepairRequest) that I have command button that
prints it out from a form based on the ID of that form. This works
fine. What I would like, and not sure if it is possible, is to have
another form where I can just select the ID from a drop-down and open
the same report.

My record source for the report is currently:
SELECT tblRepairList.* FROM tblRepairList WHERE
(((tblRepairList.RepairID)=Forms!frmSerReqEntry!txtRepairID));

I tried adding an OR statement at the end:
"OR (tblRepairList.RepairID)=Forms![frmRptRepairRequest]!
[cboRepairID]"
but it asks me for 'Forms!frmSerReqEntry!txtRepairID'

Are is there anyway to make this work, without making a new report?

Remove the criteria from the query.

Instead use the button code to use the OpenReport's
WhereCondition argument:

DoCmd.OpenReport "report name", _
WhereCondition:= "RepairID=" & Me!txtRepairID

Oh fantastic! That worked exactly like I wanted it. Thank you!