CETInnovator
Registered User.
- Local time
- Today, 13:00
- Joined
- Oct 11, 2012
- Messages
- 11
I have a macro in a form, that prompts me to enter the name of a company. Once I enter the name of the company, it returns the contact information of the person who manages the account. However, if I incorrectly spell a name or enter in a name that is not in the table, I receive a blank form.
How can I tell my query, that if the information that is typed in the prompt is not there, to return a message that instructs the user that the information is not available and they should try a new search.
Is this possible? and should this be in my query or form?
How can I tell my query, that if the information that is typed in the prompt is not there, to return a message that instructs the user that the information is not available and they should try a new search.
Is this possible? and should this be in my query or form?