L Lynn Pennington Nov 12, 2003 #1 Hi. I want to check the values of a list box before I ADD a record. Thanks, Lynn.
L Larry Linson Nov 14, 2003 #2 Check _how_ or _for what_? To use VBA code to check, put that code in the BeforeUpdate event of the Form. If it fails your validation, set Cancel = True to cancel the update and set focus back to the Control that was the culprit. Larry Linson Micrsoft Access MVP
Check _how_ or _for what_? To use VBA code to check, put that code in the BeforeUpdate event of the Form. If it fails your validation, set Cancel = True to cancel the update and set focus back to the Control that was the culprit. Larry Linson Micrsoft Access MVP