HillTJ
To train a dog, first know more than the dog..
- Local time
- Yesterday, 21:26
- Joined
- Apr 1, 2019
- Messages
- 713
Hi, this may be difficult to describe. I have a subform in datasheet view, included is a 'duedate' field (which is populated from the preceding record). I also have an 'actualdate' field which is entered by the user upon completion of an inspection. Currently, i am trialling the onexit event to trigger a vba routine that generates a outlook event for the next scheduled inspection. Is this the best way?. Should i be using a form related event? Rather that a control triggered event. I would be interested in feedback.