null value in a query adding a message

[wintergreen]

OK - Let's see: I have a command button w/ a macro attached to it that opens a form (for looking up contacts) that is based off of a query). The query requests that a last name be searched. If the Last Name is not in the database, the form comes up blank if the person does not have access to input a new contact. If the person has access (security privileges) to add a new contact, a blank contact form opens for the new info. I would like to add a message to the contact form (or query) for null values that says, "This person is not in the contact database." Then, if the person has the access to add a new person, they are taken to a blank form to add and if they do not have this access, they are taken back to the start-up form. What is the simplest way to do this???

If this is not clear, I can tell you more...

THANK YOU IN ADVANCE,
Summer

 

[PHV]

In my opinion the standard way is to use a combobox as a navigation tool.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[wintergreen]

Do you mind explaining a little more about how I am to use a ComboBox to do this???

THANK YOU!

 

[PHV]

Simply follow the wizard.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[wintergreen]

PH - Thanks for your help. I still have a couple of questions.

1. Where do I put the Combobox on the Start-Up Form that has the button that "calls" the Contact form OR on the Contact Entry form?

2. What do I put in the Combobox?

I read the FAQ on ComboBoxes as Navigational Tools, but I'm still a little vague as what specifically I should do with it. I also didn't know that there was a ComboBox wizard.

I REALLY appreciate your help.
Summer