Filtering Question

[BWG3]

I currently have a button that opens up a form, but first a dialog box appears that asks the user to enter an "ID Number". When the "ID Number" is entered, it takes the user to the specific form related to that specific "ID" number. Is there any way or any code I can place in my "on click" vb code that tell the user that the "ID Number" does not exist and will allow the user to re enter the number if there is no record of that "ID Number" in my database? Thank for your help and Happy Holidays.

 

[HiTechCoach]

I would have your dialog form do a DLookup to see if it exist before oping the form.

You could also use the form;s On Load event to check to see if the ID exists. If not, display a message then reopen the dialog form