Tabular form - disabling autosave

[Jishnu Surendran]

I have a tabular form access form bound to a query. How can I disable autosave when fields are edited in the form. I want to create a save button to prompt the update.

[June7]

Record is committed to table when: 1) table/query/form closes or 2) move to another record or 3) run code to save.

I don't think can be done with Datasheet form.

Possibly with a form set for Single view with its Cycle property to Current record and AllowAdditions to No so user cannot move to another record.

Otherwise, don't use bound form and use code to commit data.

[Jishnu Surendran]

Record is committed to table when: 1) table/query/form closes or 2) move to another record or 3) run code to save.

I don't think can be done with Datasheet form.

Possibly with a form set for Single view with its Cycle property to Current record and AllowAdditions to No so user cannot move to another record.

Otherwise, don't use bound form and use code to commit data.

I cannot use unbound text boxes in forms to get a tabular view as it won't add the next record.