For those who want to know if I was finally successful. I tried Gonzalo's suggestion about importing SQL into a query. Acess came back with an error "something Too complex". I butted heads with this before.
I defined couple of variables. Set the variables to the form controls. Put the variables into the SQL.
SUCCESS.

     strSql = "SELECT EQUIP.BLDG_NO, EQUIP.EQUIP_NO, EQUIP.EQCODE, EQUIP.LOCAT, EQUIP.SERVES" & _
                " FROM EQUIP WHERE EQUIP.BLDG_NO = " & intBldg & _
                " And EQUIP.EQUIP_NO = '" & strEquip & "'" & _
                " ORDER BY EQUIP.BLDG_NO"

My 15+ years experience has been with Rdb and SQL. Much less confusion with syntax. That worlds seems much simpler than Microsoft VBA.
Thanks for all the tips.

glad you make it work.. anyway Brian wrote a wonderful explanation about your problem ;)

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========