G
GDW
I receive the 3159 error when the following code hits the line noted by
"->".
Set rs = frmCommand.Recordset
With rs
.AddNew
' .Update
-> frmCommand.Bookmark = .LastModified
End With
I tried inserting "Update" after "AddNew" as I had seen in code
examples elsewhere but the empty record violated constraints and
couldn't be updated. "LastModified" appears to have no value (viewed
in Watch window) after the "AddNew" statement. I thought that
"LastModified" was supposed to represent both new and updated records.
Any ideas?
Thanks,
Gary
"->".
Set rs = frmCommand.Recordset
With rs
.AddNew
' .Update
-> frmCommand.Bookmark = .LastModified
End With
I tried inserting "Update" after "AddNew" as I had seen in code
examples elsewhere but the empty record violated constraints and
couldn't be updated. "LastModified" appears to have no value (viewed
in Watch window) after the "AddNew" statement. I thought that
"LastModified" was supposed to represent both new and updated records.
Any ideas?
Thanks,
Gary