I keep getting this error when I try to run some code as a search Function. The search I am doing is setup as a Yes/No in the Table, so maybe that is the issue, here is the code I am working with that is giving me the error, I am using the same basic code for 4 other searches and those are working fine, it is just this one:
'Field 3 Combo Box criteria
If Nz(Me.Combo32, "") <> "" Then
If strWHERE <> "" Then strWHERE = strWHERE & " AND "
strWHERE = strWHERE & "((High_Risk_Tbl.[Legal_Inquiry_Needed]) ='" & Me.Combo32 & "')"
If Combo32 returns anything else it won't work (except 0 or -1, the numerical equivalents to TRUE and FALSE in Access). And you won't need the apostrophes as it's not a string, it's a Boolean. Give it a shot and see if it works. Cheers!
Oh and if you need to display something else in the combo box for the user's sake ("Yes" or "No" for instance) have a look at the bound column.