I am using a parameter query to open a form, using the SSN field, and that works wonderfull, however if the SSN is not in table, it opens a blank form, which is fine, but I would like it to populate the SSN field (1st tab) when it opens the blank. Is there a way to do this?

---

Reply from Richard Rost:

Of course there's a way to do it. There's a way to do just about everything in Access. Unfortunately, I can't think of a way to do this that DOESN'T involve a little programming. Once you type that parameter into Access' default prompt, there's not a lot else you can do with it.

You could set up your own form that's not bound to a table. All you need in that form is a single text box and a command button. Type the SSN into the text box and click the button to search. The button would execute a DLOOKUP command to see if the value exists in your table. If it does, you would open the person form to that record. If not, you would open the form to a blank record and set the value.

Like I said, this will involve a little bit of programming. I cover all of this in my 300-level Access classes. Unfortunately, I can't think of a NON-programming solution for this problem. Anyone else?