See the very last "where" clause in my snippet.
The form will be called from one of two forms (either Job1 or Job2).
You will note that "Job1" is hardcoded into the "where" clause.
How do I change the "where" to simply refer to the parent form.....something like;
(which does not work, of course).
SELECT tblCustomers.CustomerName, tblCustomers.CustomerID, [add1] & ", " & [add2] & ", " & [add3] & "," & [postcode] AS FullAddress, tblCustomers.GeneralComments, tblCustomers.EngineerComments, tblCustomers.RecommendedWorks, tblCustomers.CalloutCharge, tblCustomers.EngineersWorksCompleted