469,921 Members | 2,176 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Updating Subform Records after losing focus in Access 2003

I have a main form with multiple Subforms that are all displaying Datasheet information related to the Main form record. When I make changes/adds to the records(s) in the subform and tab to another subform, it saves those previous subform records fine, but when I make changes to the subform records and then change the mainform criteria, it doesn't save those subform records.

I can use an event to prompt for saving the records on the BeforeUpdate event, but that asks that question on each record that is added in the subform. since there could be many records added at the subform, this isn't desireable. Does anyone know of a way to check the record(s) status before moving away from the subform so that changes are not lost?

I have tried to use the OnDirty and LostFocus events with no success.

Mar 26 '08 #1
0 1618

Post your reply

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

Similar topics

3 posts views Thread by Simone | last post: by
reply views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.