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

Updating records behind a form

P: 1

At the risk of showing my ignorance I wondering if anyone can advise me how best to update records behind a form. Here's the problem I am using Access 2002 and have a single form bound to a query. The form has 3 tabbed sections, if I make changes to a text box in one tabbed section and move to another tabbed section and then close the form, I lose the changes.

I can get around this by moving to the next record and then moving back before closing the form but this seems a poor fix and can't help feeling there is a more elegant way for forcing the records to update. Requery and refresh clear information I have displayed in a subform so aren't ideal. I've tried approaching the problem using recordsets and the update method but have run in to problems with this coding, as it appears I need to have a addnew or edit method proceeding the update method.

Any advice much appreciated.

Oct 22 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,492
Interesting question. The tabs (pages) are, in fact, irrelevant.

Saving records on forms is generally done automatically whenever you move off the current record. There is a "Save Record" menu option (under the Records menu). This can be invoked using the hotkey Shift-Enter, or you can even put the code behind a Command Button control on your form.

Welcome to Bytes!
Oct 24 '08 #2

Post your reply

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