Search results

I have a parameter query that uses [Enter Name] for user input. If a user enters a name and presses ok the query brings up the required results. If user presses ok without entering anything in box I get wrong results. Anyone know how I can stop users from just pressing ok without entering name?

Thanks Mile-O-Phile, I was on the right line but couldn't just get there. It helps with a little clue!

Hi - Can anyone give me any pointers on how I can check to see if a table exists. I have some code that creates a table but if the table exists already I get an error message. I want to be able to check before the make table code is run.