When it hits the strVendorNum = line it gives me an "Object Required" error message.

OK, I fixed that error, but now when I run the query it is asking me for strVendorNum in a dialog box.

Any chance you could copy the code and paste it in a posting, or email it to me?

Mike
EchoVue.com

Edit: Editing out since code didn't work, no sense having non-functioning code lying around.

Before I look at it too hard, try and replace the asterisk's (*) with percent signs (%) for some reason Access uses one in the Query Builder and a different one from VBA.


Mike
EchoVue.com

Substituting % for * in the first query resulted in no records being returned.

You then need to ensure that the search string is surrounded in quotes as well.

LIKE '%' & '" & strSrch & "' & '%'



Mike
EchoVue.com

That query is already working with the asterisks, it returns the PCAGE & ACAGE columns associated with a given full or partial part number. It is the second query where the vendors are compared to the list of vendors in the ACAGE column (boo to bad database design) that is giving me fits. Thanks for the help, if I still can't get it working tomorrow I'll be back!

Sounds good - I am about to head for the night as well.

All the best,

Mike

Mike
EchoVue.com

Success! Found this on the web today and was able to leverage off it to find the code I needed!
http://www.techonthenet.com/access/q...ke_textbox.php

Here's the SQL statement that worked, as entered into VBE:
    sql_q = "SELECT DISTINCT * " & _
            "FROM Vendor, qryPartSearch " & _
            "WHERE (qryPartSearch.PrimVendor = [Vendor]![id]) OR (qryPartSearch.AltVendor Like '*' & [Vendor]![id] & '*' ) " & _
            "ORDER BY id;"

Edit: By the way, is it possible to make the ORDER BY statement such that it puts the PrimVendor listing first, and the rest in numerical order afterwards?