Split Form (1 Viewer)

[Steven.Ashby82]

Is it possible to filter the table view of a split form based on both the date value on the form and the value of a cbo?

Thank you

 

[Steven.Ashby82]

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...

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?

Kind Regards