One filter not working on an Allen Browne search form

[Eddy Sincere]

I built a filter form using the Allen Browne example and it works great except for one text box. I use both text and combo boxes for a total of 8 fields. The second field (

I'm not getting any error codes and the field names are correct. I've attached some pics of the form, the form working correctly, the VBA code and the query.

I've tried deleting the field and associated VBA line and inserting a new text box and VBA. My data properties are the same as other text boxes in the form.

I've reviewed the query and everything seems in place. It's really basic.

What am I missing?

Form






Form Design ("First" text box with field properties)




VBA




Query

[ranman256]

ID fields ...EmplyeeID are usu. numeric, if so, remove the single quote around the filter ' " & txtEmpID & " ' ". Quotes are only for strings.

and
you cant use LIKE without an asterisk. "[Activity] like '*" & cboActivity & "*'"

[Eddy Sincere]

Got it. You're correct, I had the wrong quotes/asterisk. I knew it was something simple.

Thanks for taking the time to answer. Problem resolved.

[June7]

If the parameter doesn't use wildcard with LIKE, might as well use = sign.

Is EmplyID a number field? If yes, remove the apostrophe delimiters.

Which field is the issue with?

Do you have Lookup set in employee information table on any of the fields? What is actually saved into employee information table - ID or text? Do combobox RowSource have lookup? Is value of combobox an ID or actual text?