I have a combo box on my form that searches for a serial number. If that number has not yet been produced the from goes to the first record in the table. I need code that will bring up a message box saying the unit has not been produced and have the form remain on the present record.

Thanks in advance

Search Help for the NotInList event....