Hello,
I am new to MS Access in terms of using the Macro functions. I am trying to create a search button which will return a set of forms related to a particular person which I have created a table for.
At present I have got this to work by linking a query (and its form) to the textboxes in search form and using the open form Macro on the button located on a search form. However, if I enter the details of a person who does not already exist in the person details table, the form still appears but without a related record.
What I would like is an error message to appear telling the user that they have entered their search details incorrectly instead of bring up a blank form?
Sorry to be a pain and probably very vague request.
Macftm
I am new to MS Access in terms of using the Macro functions. I am trying to create a search button which will return a set of forms related to a particular person which I have created a table for.
At present I have got this to work by linking a query (and its form) to the textboxes in search form and using the open form Macro on the button located on a search form. However, if I enter the details of a person who does not already exist in the person details table, the form still appears but without a related record.
What I would like is an error message to appear telling the user that they have entered their search details incorrectly instead of bring up a blank form?
Sorry to be a pain and probably very vague request.
Macftm