I should mention that this is a maintenance problem, as this database was complete and used in previous competitions, but the user needed it to be slimmed down.
I'm an Access 2007 newbie, but everything has been going fine until this.
To access this dialog box, in the Errors in Linked Tables Dialog Box, click Options.
So my question boils down to, how can I tell what happens when the form closes? In a nutshell; a form will save directly to a table if that table is selected as the record source for the form.However, the following changes to the Excel table can cause errors: When you refresh a Power Pivot linked table and the source table in Excel has changed, this dialog box presents options for fixing the errors.