dbseechanges option with Openrecordset Error 1

[Sydney1]

Hi,

Happy new year to everybody.

I have the following code

Set MyDB = CurrentDb
        Set MyTable = MyDB.OpenRecordset("tblLoanSteps", , dbSeeChanges)
        MyTable.AddNew
        MyTable("litigationID") = Forms!frmLitigationEntry!txtLitigationID
        MyTable("ScheduleDate") = Forms!frmLitigationEntry![txtstartDate]: MyTable("Steps") = "1": MyTable("Critical") = "1"
        MyTable.Update

which adds a record to a table. But every other time I run the code I get the following error "You must use the Dbseechanges option with Openrecordset when accessing a SQL Server table that has an identity column."

I've used the dbseechanges option, but am still getting the error every other time I run the code. Any help would be greatly appreciated.

Thanks

Sydney

 

[SonOfEmidec1100]

I believe dbseechanges only works for a dynaset type recordset.

 Set mytable = mydb.OpenRecordset("tblLoanSteps", dbOpenDynaset, dbSeeChanges)

 

[Sydney1]

Thanks for the reply. You're exactly right. I put in the dbOpenDynaset and it worked fine.

Thanks again for the help.

Sydney