467,167 Members | 987 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,167 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.

Thanks
Mar 26 '08 #1
  • viewed: 1532
Share:

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
1 post views Thread by google@darincline.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.