I have a filed that is required for a record. The problem is, lets say, if someone accidently put something in that filed and then delets it because they did not want to start a new record . Access faults with "The field "Lab training. signed off date" can't contain a null value because the required property is true.etc." .I want it so that when they press different record data button, it does not continue to show that until you close the table and restart it.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
error handling
- Thread starter merlin72
- Start date
merlin,<br>The only way you'll get that message is if the user tries to save that record without data in that field. If you just want to back out of the record, you can use the .Undo method, or use sendkeys "{Esc}", or sendkyes "{Esc}{Esc}", in whatever event or button you choose. ie, a button labeled Undo, could have either the senkeys or the Me.Undo statement.<br>--Jim
- Status
Similar threads
- Locked
- Question
