upsize table and form to SQL Server with Identity Column

[bigoldcloser]

I have a very simple form that I use to enter data for a table. I upsized
the table to SQL Server and linked it. In some underlying code, when
I try to update a column in the table that the form is using as the source
I get the familiar, "need to use dbSeeChanges in OpenRecordSet for linked
SQL server table...."

My problem is that I think the form does the OpenRecordSet in the background
when the form is opened, so I don't know how to set the dbSeeChanges option.

This is what I'm doing:

strSQL = "update employee set employee_save_date = now() where emp_id =
Me.emp_id
CurrentDb.Execute strSQL, dbSeeChanges

This executes when I hit my save button I created on the form. The error
then pops up on the screen. Any ideas?

Thanks!

Bill Auslander