vba rs.update causing odbc error 3146
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![Prefix_CTRL_NBR] = Me.Prefix_CTRL_NBR
rs![CTRL_ID] = Me.CTRL_NBR
can someone help?