Why are the subform records locked?

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
 
M

M Skabialka

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top