I have this code working for Field1 (Last, First names):
Dim strInput As String
strInput = InputBox("Enter Last, First")
DoCmd.OpenReport "FAX", acViewReport, , "Field1 = '" & strInput & "'"
I need a second field "Report_Number_Subjects" filtered as well. This field is in a subreport of "FAX" named"FAX_Subjects." The source of the subreport is a table "Request_Subjects."
If an input box isn't the best way to go should I tie the filters to unbound text boxes? If I do that how do I code for it?
Dim strInput As String
strInput = InputBox("Enter Last, First")
DoCmd.OpenReport "FAX", acViewReport, , "Field1 = '" & strInput & "'"
I need a second field "Report_Number_Subjects" filtered as well. This field is in a subreport of "FAX" named"FAX_Subjects." The source of the subreport is a table "Request_Subjects."
If an input box isn't the best way to go should I tie the filters to unbound text boxes? If I do that how do I code for it?