what causes a read-only form error message on a sub-form?

J

John

what would cause a read only error message on a sub-form? there is a
secondary form with a sub-form (that works properly) linked to the same
primary table. Could the link on autonumber or enforcement of referential
integrity be causing problems?
 
T

tina

if your subform is based on a multi-table query, it may not be updateable.
try opening the query by itself, and see if you can add records. if not,
your query may need to be constructed differently, or you may need to
rethink your approach. if you can add records to the subform's underlying
query or table independently, then the problem is probably in the subform
properties. check the AllowEdits (Yes to edit existing records) and
AllowAdditions (Yes to add new records) properties of your subform, and the
RecordsetType property - which should be set as Dynaset. also check to see
if you have any macros or code in the parent form or in the subform, that
resets these properties at runtime.

hth
 
Top