vba rs.update causing odbc error 3146

[sharon.chapman7]

Hi,
I am getting an error 3146 odbc on rs.update. I have a form (form1) based on table motion_imagery. In form1, using

VBA I'm trying to load two fields from form1 into table 2, File_Books.

Set db = CurrentDb()
Set rs = db.OpenRecordset("dbo_Filestream_Files", dbOpenDynaset, dbSeeChanges)

rs.MoveLast

rs.Edit
rs![Prefix_CTRL_NBR] = Me.Prefix_CTRL_NBR
rs![CTRL_ID] = Me.CTRL_NBR
rs.Update

can someone help?

thanks,
Sharon