Updating records behind a form

[Ands]

Hi

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.

Cheers
Andy

[NeoPa]

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!