Bound Form - Manual Recordset Update?

[Dan]

Hi, I have a bound form with bound text box controls. I would like to have SAVE button so the record can be updated in place. However, it seems binding the form and controls to a recordset prevents and in-place save. Is this a limitation of using bound controls? TIA

[Robeen]

When you move off the current record in your Form - Access automatically saves the record before displaying the new record.

That has always been my experience - if the Form bound to a Table.

Is your Form bound to a Table - or to a query?

[Dan]

Yes the form is bound to a table. I want to have an explicit SAVE using a button. But there appears to be no way to do this. I also toggle to datasheet view so I don't want to have to unbind the controls if can avoid that. Any ideas on how to do this.

[Robeen]

When you put a button on your Form Access should bring up the Command Button Wizard.
One of the options in the Wizard is 'Record Operations'.
If you select that, you will see a Save Record option . . .

Have you tired this already?

I have used this method in several versions of Access - even though I have never used Access 2007.

[Dan]

Using the Macro Language did it. Thanks! I program languages so never thought about trying the macro. Strange the macro commands are not exposed in VBA.

[Robeen]

You can include those Macro Commands in VBA - using DoCmd.

[Dan]

Thanks much. Need to read up on the DoCmd function!