My question pertains to Access Search Seminar Lesson 24 time index 2:37, when you did your search for "rick" and there was no record. Is there a way to have the code fire a MsgBox "Record Not Found." as opposed to just leaving the list box blank?
Very Respectfully, Jimmy Mitchell
Reply from Richard Rost:
Sure. Keep watching. In one of the next couple of lessons I show you how to put counts of the number of records found in a box below the list. You could just use an IF statement to pop up a message if the count is zero.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Search Seminar.