Recent content by VBANOOBY

MSAccessRookie, you are correct, I want to view records if ANY of the conditions are met and therefore, the OR statement is the best way to do this. I edited my code to the following but I get a "Syntax error" when it trys to run: ' If Title If Nz(Me.Title) <> "" Then ' Add it to the predicate...

OK my first post so please be patient with me, and thanks in advance for any and all help! I have an Access 2007 database where I want the user to be able to type a few charactors into a field and then compare (search) several other fields to return all records that contain those typed-in...

First, I just want to say THANK YOU for all the help I've gotten from the various people on this site. You are all a great source of information and while my experience with Access is limited, I too hope to contribute some day. I work with audio systems for commercial use (hospitals, airports...