check all values of a row when leaving ACCESS 2003 form
Is there a simple way to check all the fields of a row when the user leaves no matter which field they are currently on in the row? That is, if a user clicks in field 3 of a row that has 10 fields, then when they exit that field, I want all the fields of that row validated. Is this possible?
Sandra
Microsoft ApplicationsMicrosoft DevelopmentMicrosoft Access
Yes, I want them to do things in a very particular sequence and I figured it would be a function call.
Dale Fye
If you make it a function (rather than a subroutine), you can simply type:
=FunctionName()
in the "On Lost Focus" or "On Got Focus" event of the control in the Properties Dialog box. Actually, you could select all of the controls at once, and make a single entry as above and it will apply to all of the selected controls. BTW, the function would not have to return a value
If you are adamant that the steps be completed in a very specific sequence, I would recommend using the GotFocus event.