- Local time
- Yesterday, 16:11
- Joined
- Oct 29, 2018
- Messages
- 21,510
Interesting. I do see [name] in the source.Here is the query that I am using for the form
Code:SELECT tblMA_workload.lPersonID, tblMA_workload.DMISID, tblMA_workload.ien1, tblMA_workload.result, tblMA_workload.Name, tblMA_workload.dtfixed, tblMA_Audit.AuditCompleted, tblMA_Audit.dtAuditDate, Month([dtfixed]) AS mth, Year([dtFixed]) AS Yr FROM tblMA_workload LEFT JOIN tblMA_Audit ON tblMA_workload.lPersonID = tblMA_Audit.lPersonID WHERE (((tblMA_workload.Name)<>[Forms]![Login_frm]![cboUser]) AND ((tblMA_Audit.AuditCompleted)=No Or (tblMA_Audit.AuditCompleted) Is Null));
Its a continuous form. I was trying to get just cboTechnician to filter the data and I couldn't get it to work even when I took out the other code for the other combo boxes.
Okay, let's go back to this. What happens?
Code:
If Me.cboTechnician > "" AND Me.cboTechnician <> "All Technicians" Then
strCriteria = strCriteria & " AND [name]='" & Me.cboTechnician & "'"
End If
Debug.Print strCriteria