CODEWITHSUNDEEP
ms-access
Ginger
Ginger

Reputation: 1

Changing message box activation

My database has a unique field for the name of the child receiving gifts from our Christmas project and notifies us of the duplication as we leave the record. However that is many keystrokes later. Is there a way to activate the message upon leaving the field rather than the record.?

Upvotes: 0

Views: 19

Answers (1)

Gustav
Gustav

Reputation: 55816

Yes, use the BeforeUpdate event of the field. In this, look up the value entered and, if found, set:

Cancel = True

and pop a messagebox.

Upvotes: 1

Related Questions