Error Handling (1 Viewer)

[knothed]

I have a command button on a form that opens another form based on a query and prompts the user for a serial number. It works fine until the user types in a serial number that has not yet been produced. Then an access error occurs and the user has to click ok in the message box and then on Halt to stop the macro. I need to know how to display a custom message box telling the user that the serial number has not yet been produced and have the macro stop when the user clicks ok. I am VB impaired so please try to keep any suggestions rather simple....Thanks