Hi All, I have a report based on a select query. How could I open the report by clicking a button on a form and the criteria input dialog does not show up but automatically get the value of a textbox from the form?
Should I use the wherecondition, or OpenArgs?
I tried this but it didi not work.
Private Sub Command2_Click()
DoCmd.OpenReport "rptPartsList", acViewPreview, , , , OpenArgs:="Me.txtRepairID"
End Sub
Could somebody give any suggestion?