Keyword, combo box and option group intersect search

[argel]

Hello guys! I'm new in Access and as such there are small details that escape me. I'm building a database of equipment composed of its characteristics and mobilizations. I have a form that allows the user to search the equipment by keyword, location, equipment center and status. In a button click search if I intersect the search of the keyword and the location it works but in the other cases gives me error. I have tried different solutions but none of them worked out. I will attached my database file for better understanding. "LISTA_EQ" is the equipment description table, the "LOC" table is the mobilizations table, the "CC_DEQ" is the cost center of the equipment table and "STATUS" is the status table,where "AV" means damaged, "SV" means in service, "PQ" means in park and "?" unknown. The form in question is "SEARCH_EQ".

[twinnyfo]

Argel,

Welcome to Bytes!

In general, none of the experts here at Bytes are going to voluntarily open a database from an unknown source. Additionally, many of us are behind firewalls which prevent us. Rather than sending your DB, please post samples of your queries--both the ones that work as well as the ones that don't. Let us know what you desires results are, what the actual results are and if there are any system errors that result.

This will allow us to directly troubleshoot your problems, rather than forcing us to hunt it down.

This is the standard practice of this forum.

Hope this hepps!