Bind your report to a query with this SQL definition:
Code:
SELECT TechnicianTbl.Technician, ForkliftServiceTbl.ServiceDate, ForkliftTbl.ForkliftNumber, ForkliftServiceTbl.ServiceDetails FROM TechnicianTbl
INNER JOIN (ForkliftTbl INNER JOIN ForkliftServiceTbl ON ForkliftTbl.ForkliftID_Pk = ForkliftServiceTbl.ForkliftID_Fk)
ON TechnicianTbl.[TechnicianID-Pk] = ForkliftServiceTbl.Technician
Then, on OnClick event of a command button in the form that you refer, insert those lines of code:
Code:
Dim strWHERE As String
strWHERE = "([TechnicianTbl].[Technician]=" & Me.cboTechnician _
& ") AND ([ForkliftServiceTbl].[ServiceDate]" _
& "BETWEEN ((#" & Me.txtStartDate & "#" _
& ") AND (#" & Me.txtEndDate & "#)));"
Debug.Print strWHERE
DoCmd.OpenReport "MyReport", acViewPreview, , strWHERE
Replace the "MyReport" with the real name of your report, choose a Technician, insert the start date and the end date, hit the button and let me know if it works.
Good luck with your project!