469,625 Members | 1,497 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

a2k - clash of beforeUpdate event and changing tabs on a subform

My beforeupdate event on the main form fires when a change has been made and
the record has not been saved (2 variables are used to track this).

Works great but if they make a change in my subform which is in one tab of a
tab control, and then they select a different tab, the beforeupdate event
fires.

So they get prompted as to whether they want to save the record - however
the idea is that the event only fires if they try to close the form or
change records.

How can I stop the event firing when they change tabs? BeforeUpdate seems
to happen before the tab change event for example.

thanks
Martin
Nov 13 '05 #1
0 1374

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by William Wisnieski | last post: by
reply views Thread by adolph | last post: by
2 posts views Thread by Mark F. | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.