I have created a database with several many to many relationships using join tables.  I have tried to follow Richard's conventions for naming and table/form/query design.  The tables all work fine.  My query works if I type the exact seach info into the criteria fields.  Now I am trying to create a search form like Richard uses in his lessons.  In the query, when I link the field in the search form to the query it works great.  The minute I add a second field to search on and run the quiery I get an error "Syntax error (missing operator) in query expression 'SubcontractorInfoT' where SubcontractorInfoT is my main table.  The criteria I am using is in the format "Like "*" & [Forms]![SubInfoQueryF]![SubDivSrch] & "*" Or Is Null".  If the answer is "Mike you're an idiot go watch lesson xx I'm OK with that.  Any thoughts?  TIA