Why are the subform records locked?

  • Thread starter Thread starter M Skabialka
  • Start date Start date
M

M Skabialka

I create many forms with continuous subforms which work OK, but I have one
where none of the records can be changed in the subform. It's though they
are locked, but they aren't.

If I open the subform by itself I can change values, but as a subform on the
main form I can't.

From the main form the subform properties are enbled, not locked, and the
correct records show up because of the child/master link field.

The subform itself has a table as the record source.
Allow filters yes
Allow edits yes
Allow deletions no
Allow additions yes
Data entry no
Recordset Type Dynaset
Record Locks No locks

This is how all of my subforms are.

What step am I missing to make the records editable???

Thanks,
Mich
 
I found it;
I had coded
Form.AllowEdits = false
on the main form until certain procedures were followed, then not turned it
off!
Not sure why I was then allowed to change data on the main but not the sub
form.
Problem fixed.
 
Back
Top