By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,689 Members | 1,787 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,689 IT Pros & Developers. It's quick & easy.

Updating Subform Records after losing focus in Access 2003

P: 5
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
Share this question for a faster answer!
Share on Google+

Post your reply

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