Updating record without exiting record on form 2

[TracySHC]

I have a form which lists multiple records from a table (each record only needs one field updated), and which also contains a control button. If the user enters a value in this one field of a record on the form, then clicks on the control button, the value is not recorded in the underlying file. How can the record in the underlying table be updated when the control button is clicked?
Thank you in advance for any help and advice,
TracySHC

 

[seaport]

What is this control button for?
You may add a simple SaveRecord command in the event procedure of that control button.

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

 

[TheAceMan1]

How are ya TracySHC . . .

[blue]   DoCmd.RunCommand acCmdSaveRecord[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]