Run time error 3705 - Syntex error (Missing operator) in que

[avan]

Hi HansV,

I have attached my sample work. When i put <all> and search, there is no problem.
But, when i search by filtering, error prompt up.
Please assist me.

Thanks.

[HansV]

Thanks, that is helpful.

There are two problems:

1) The WhereCondition should not start with the word "WHERE", you only need to specify the condition itself.
2) The combo boxes filter on CompanyID and CountryID, but those fields are missing from the record source of frmsubClients, so you have to add those two fields.

See the attached version.

dbSearchExample.zip

[avan]

Hi HansV,

Thanks a lot.