Adding Error Message

[desibabu90]

Hey Everyone,

I have a form that requires the user to input an ID number and using that ID number I have created a button that opens a different form with that same ID number.

I wanted to know how to program an error code so if the user enters a non-existent ID number, the error message would display "Please Enter Correct ID"?

Thanks!

[RuralGuy]

Do a DLookup() or DCount() in the BeforeUpdate event of the ID control.

[desibabu90]

how exactly would this work? if Dlookup cannot find a record doesn't it return a null value? with the code i have, if i put in a non-existent ID it will just return a blank screen..i want an error message to pop up.

[RuralGuy]

Put your MsgBox up in the BeforeUpdate event of the ID control and set Cancel = True to hold the focus in that control.