report based on a query

[blueraincoat]

Hi all is there any way to have a MsgBox to replace the popup dialog box of a report that is based on a query?
I don't want the user confused by the criteria (forms!tblPartsOutbound!RepairID)
I tried the code below, but it still pop up the criteria box...
Any comment appreciated!

Private Sub Command2_Click()



Select Case MsgBox("Do you want view the Replaced Parts List of " & Me.txtRepairID & "?", vbYesNo, "Replaced Parts List By Repair ID")
Case vbYes
DoCmd.OpenReport "rptPartsOutbound", acViewPreview, , "[forms]![tblPartsOutbound]![RepairID] = '" & Me.txtRepairID & "'"
Case vbNo
Me.Undo
End Select
End Sub

[pbaldy]

That form reference is supposed to be a field in the report's source. The syntax is like this (it's the same for OpenReport and OpenForm):

http://www.baldyweb.com/wherecondition.htm

If you still have a criteria in your query for this same value, you should take it out. The wherecondition argument of OpenReport replaces it.

[blueraincoat]

Thank you very much Paul!
It works great. Never thought it could be this easy...
And the website is very great too, I will take a deep look inside.

[pbaldy]

Happy to help, and thanks! I'm trying to make it a helpful tool.

[blueraincoat]

I'm very sure it's a very usefull website.
It's a great job.