Queries :: Adding Test Field To Different Table And Try Different Query Using Like Parameter

I'm using Access 2003...I have a query that searches a parts table by description:

Like "*" & [Enter in Part Description to search] & "*"

I need to add another search to this query, I added another field to the parts table call manufacturer. I add this field to the above query and added this parameter to it:

Like [Enter in Manufacturer] & "*"

I then added a manufacturer to one of the fields for test purposes. For some odd reason this doesn't work. If I take out the manufacturer parameter and don't enter in anything into the part description the query returns all the records. When i type a description into the part description field the query returns the proper records. When I add back the manufacturer parameter and enter through both parameters only the one record returns showing the test record instead of all of them. If I put a part description in and enter through the manufacturer parameter no records show when they should.

I've tried adding a test field to a different table and tried a different query using the like parameter. The parameter works in a field already in the table but won't work with the new field I added. I've done compact and repair.