We help IT Professionals succeed at work.

On Exit of Record

peispud
peispud asked
on
339 Views
Last Modified: 2012-02-11
I am using Access 2010 in VBA

I am using a form to edit / add to "TableA".

I would like to make changes to a particular record in "TableB" (via recordset) only just after "TableA" has been updated but just before exiting "TableA".

I'm not finding a "Before exit of Record" in the VBA  drop down.

Thanks
Comment
Watch Question

This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Hamed NasrRetired IT Professional
CERTIFIED EXPERT

Commented:
After update is the event that saves data to tableA.
Is that what you mean, to make changes to a record in TableB?
Hamed NasrRetired IT Professional
CERTIFIED EXPERT

Commented:
You don't exit a table as such. You may exit a form bound to TableA.
CERTIFIED EXPERT
Top Expert 2009

Commented:
I have long wished that there was a "Before Exit of Record" event (or some such) -- sort of the reverse of the Current event.  It would certainly come in handy for certain situations.  But (as others have said) you actually need the BeforeUpdate event in this case.
peispudTech

Author

Commented:
Exactly what I was looking for. Thanks
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.