I created a form and on that form is a textbox called tbxJobNum. I enter a Job Number into that box and then click the Submit button in the bottom of the form. The Submit button has a macro built on it that I want to pass the JobNumber from the tbxJobNum box to the Report that it is opening. I can only assume that my where condition is currently incorrect as I'm not getting any records to return.
The current Where clause is
[Reports]![rptForm1]![jpJobNum]=[Forms]![frmFAI]![tbxJobNum] Or [Reports]![rptForm1]![jhJobNum]=[Forms]![frmFAI]![tbxJobNum]
I want this clause to function as I have the criteria set up in the query originally as pictured below.
Thanks in advance for the help!