Turn AutoSave Off for a Specific Tab

[crhodus]

Hello Everyone,

We've been asked to add an additional tab to a form for one of our customers so that data can added to a new table in the database.

Currently, if a user adds or edits a field, the form saves the data to the database as soon as that item looses focus. We want to make minimal changes to their form because it was poorly written by someone with minimal Access experience, it is not in our contract, etc... The only modification will be to add an additional tab with text boxes so that they can enter data into a new table.

Is there a way to have the autosave feature active for all tabs except for the new tab that I'm creating. If they add/edit/delete/ a record from my tab, then I would like to prompt them to save their changes before moving to another record or tab.

Thanks,
CRhodus

 

[RuralGuy]

I assume you will be putting a SubFormControl on this new tab. Simply ask your question in the BeforeUpdate event of the new SubForm and do a Me.UnDo if you want to eliminate any changes.

 

[crhodus]

Thanks for the info. I didn't think to use SubForms but that seems to make for the easiest solution.

Crhodus

 

[RuralGuy]

Glad I could help.