No Record - Blank Form

[papasmurfuo9]

Hi

i have a form with a drop down that links to a table where a user can select or type a record,

if they type a record that isnt in the table, the form goes completely blank

is there a afterupdate event i can do so that if the record doesnt exist, then a msg prompts and the form isnt compeltely blank?

thanks in advance

 

[pr2-eugin]

What version of Access are you using? If you are using A2007+ (I think) then you can make use of the NotInList event.

 

[papasmurfuo9]

thank you eee