i have used a combo box on a form linked to a query. the user is to select a value from the combo box and this click 'Find'. But on an old occasion where the user has forgotten to select a value from the combo box, left blank, i want it to display an error message saying, "Select value", when clicked 'Find'.
As well as displaying an error message, can you also instead of displaying an error message have it to automatically open a form which has the error message and also, the instructions for the user.
It would be great if someone could explain how i could achieve both, the error message and to automatically open a form. any help would be highly appreciated.