Hi, Again Everyone:
In my post on February 7, 2008, How do you display a message box in query, I am trying to find out how to write the code for the procedure. That is once query is higlited and you click open and once query opens a Enter Parameters Value dialog box is displayed with a blinking cursor waiting for the user to insert data into it.
When I insert a three or four digit number as one of the numbers I have below and press OK I wil get get the number displayed in a Select Query dialog box. The query is doing what it is suppossed to do. But if I insert a number that is not in my database and press OK it will return a Select Query dialog box with a blinking cursor in an empty record row. That is allright I can live with that because I know the number is not there. But what I want to do is have a message box displayed "Number not found" when I press OK. I just want to know how do you go about writing a procedure to have a message box displayed "Number not found". My database is not connected to a server. It is on my C drive as: "C:\lottery\lottery numbers.mdb"

I have a database that has two fields:

Header Three digit NH Four digit MA low to high

Book02303 1279
Book02304 008
Book02305 899
Book02306 009
Book02307 4567
Book02308 3799

In the Design menu for query the wording I use for Criteria: [type Three digit NH Four digit MA, low to high]

Once again I would truly appreciate anyone's help in how to write code to include a message box. Thanks. Tyrone!

Maybe this question would be better answered in the Access VBA forum....????