By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,822 Members | 1,042 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,822 IT Pros & Developers. It's quick & easy.

Is there an event trigger when moving off record?

100+
P: 167
I have an access page that has a subform. The subform is in datasheet view. I cannot seem to find an event that I could trigger when I move off of a record, either as a new insert or after updates have been done. I have tried using the Form event 'after update' but it triggers for every single column if it has been changed, I don't want that. Is there some event or method that I could use when I lose focus on the current record, either by tabbing to the next row or using the mouse to move off the record?
May 25 '07 #1
Share this Question
Share on Google+
1 Reply

puppydogbuddy
Expert 100+
P: 1,923
I have an access page that has a subform. The subform is in datasheet view. I cannot seem to find an event that I could trigger when I move off of a record, either as a new insert or after updates have been done. I have tried using the Form event 'after update' but it triggers for every single column if it has been changed, I don't want that. Is there some event or method that I could use when I lose focus on the current record, either by tabbing to the next row or using the mouse to move off the record?
Try using the Form's current event.
May 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.