Search function is not working

[zonexs123]

Dear MVP's & Experts,

Recently I am trying to build a search function on a form where there is a subform which is relate to query. Through few Combo box selection, I need to search item into subform which has been placed on main form. Also there is a Reset button which will reset the search criteria however its not working.

Also whenever I try to click the search button it shows following error:

Rune-time error ‘3075’:
Syntax error (missing operator) in query expression ‘[Month] LIKE “All*” AND [LOB LIKE “All*” AND [RequestType]>Binder AND [ProcessedBy]<All’.

I don't know where I am doing wrong but still not able to resolve this issue.

Would be appericate if you can help me out in this. If there is any other alternative for same scenario then please let know.

Database (.accdb) attached. (sorry... I couldn't able to upload in zip format)

Santosh

 

[spikepl]

To be honest, if you want to program you have to learn to sort out the very basic syntax errors yourself. This is not difficult, but requires panic to be thrown overboard.

Access was even so kind as to tell you there is a syntax error, and provide you with the bit it doesn't like. Since you did get it right in the first bit, you do know what it is supposed to look like in the second bit.

[Month] LIKE “All*”
AND
[LOB LIKE “All*”