Using Access to Edit SQL Table: Form with Multiple tabs

[dantebothermy]

I have an Access form with multiple tabs; the underlying table is in SQL Server.

The problem comes up when I edit and save a record on tab 1, then go to tab 2 to to edit a different field of the same record. I get the following error message:

The data has been changed

Another user has edited this record and saved the changes before you attempted to save your changes. Re-Edit the record.

If you click OK in the dialog box, Access will let you edit the record.

The problem does not occur when the tables are in Access rather than SQL.

Any ideas?

Thanks,


Dante

[ADezii]

I have an Access form with multiple tabs; the underlying table is in SQL Server.

The problem comes up when I edit and save a record on tab 1, then go to tab 2 to to edit a different field of the same record. I get the following error message:

The data has been changed

Another user has edited this record and saved the changes before you attempted to save your changes. Re-Edit the record.

If you click OK in the dialog box, Access will let you edit the record.

The problem does not occur when the tables are in Access rather than SQL.

Any ideas?

Thanks,


Dante

You could try a Requery of the Form's Record Source, then return to the same Record.

[dantebothermy]

ADezil,

thanks for the reply.

The record source is a table, not a query. Would the equivalent be to refresh the data?

[ADezii]

ADezil,

thanks for the reply.

The record source is a table, not a query. Would the equivalent be to refresh the data?

Refresh and Requery are definately not the same. After applying a Refresh to a Form, the current set of Records won't include Records that have been added or will it exclude Records that have been deleted since the database was last Requeried. Also, it will not exclude Records that no longer satisfy the criteria of a Query or Filter. To accomplish the above, you must Requery. The Refresh Method is used primarily to reflect changes made to the Data by you and other Users in a Multiuser environment. In your current context, a Refresh may actually work.

[NeoPa]

The problem comes up when I edit and save a record on tab 1, then go to tab 2 to to edit a different field of the same record.

You say you have saved the record. If this is true then a Refresh ought to work. If you're getting this message under these circumstances anyway, I assume that you would need to refresh each page (or tab) separately though.

Also, you don't say, but I suspect you have subforms on your pages. Is that right?