Just to give a bit more detail I want to have a combobox called cboTechnician filter the entries on the Datasheet to only select that Technician. The field on the data sheet is called 'Technician' so I used the code...
Code:
Private Sub cboTechnician_AfterUpdate()
Me.Filter = "[Technician] = " & Chr(34) & Me.cboTechnician & Chr(34)
Me.FilterOn = True
End Sub
Unfortunately this throws up an error... Run-time error '3464'
Data type mismatch in criteria expression
Can anyone help out as to what the cause of this is?