Which event triggers on entering data into a subform field ? 'On Enter' ?
- Thread starter liamfitz
- Start date
spikepl
Eledittingent Beliped
- Local time
- Tomorrow, 00:16
- Joined
- Nov 3, 2010
- Messages
- 6,134
boblarson
Smeghead
- Local time
- Today, 15:16
- Joined
- Jan 12, 2001
- Messages
- 32,040
I don't know if the link by Spike comes up with anything for you but it didn't for me. So, just a brief statement -Is this right ? thanks.
On Enter has nothing to do with data. It is when you arrive at a form or control. It is related to Got Focus and I'm not real clear on why the two exist as separate, so even after all of these years I still learn things too.
Here's a link which might help:
http://office.microsoft.com/en-us/access-help/order-of-events-for-database-objects-HP005186761.aspx
- Local time
- Today, 23:16
- Joined
- Sep 12, 2006
- Messages
- 16,075
the main events you want are probably these
the control's BEFORE UPDATE event
- just before you leave the control. in this event you could check whether the entry makes sense. in not, you CANCEL the event, which forces the user to re-enter
the control's AFTER UPDATE event
- after you leave the control. in this event you can address any issues that result as a result of selecting the particular field, or value
the control's BEFORE UPDATE event
- just before you leave the control. in this event you could check whether the entry makes sense. in not, you CANCEL the event, which forces the user to re-enter
the control's AFTER UPDATE event
- after you leave the control. in this event you can address any issues that result as a result of selecting the particular field, or value
