Recordset is not updatable

  • Thread starter Thread starter Trent Argante
  • Start date Start date
T

Trent Argante

I have a main form that has a subform.
I changed the name of the subform and updated the links
accordingly so that the data shown is correct.
BUT (notice my by BUT) I can no longer edit the main
form's data nor the subform's data within the form. I can
at table leve, but not at form level. I also can't edit
the data at subform level.
Error: "The Recordset is not updatable."
TIA
Trent
 
SOLUTION:

The errors were due to the following:
1) A circular table reference at the main form's query-
level, which was removed, and
2) A circular field reference in the subform's SQL
statement, which was also removed.

I am very new to SQL, so that's about the best explanation
I can provide at this time. I ended up fixing it without
really knowing what I was doing...I hope...

HTH
Trent
 
Back
Top