Split Form

Steven.Ashby82

Registered User.
Local time
Today, 23:53
Joined
Jan 14, 2013
Messages
63
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
 
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?

Kind Regards
 

Users who are viewing this thread

Back
Top Bottom