Software

Question

Locked

read-only settings for Access forms and subforms

By chocolatte2 ·
Hi,
I'm having a problem setting my Access (2003) form to read-only.
I have a form (frmSurvey) that has a subform (sfrmCount). When frmSurvey opens, I want it to be read-only. To make any edits or additions, the user will need to press a command button. On frmSurvey's OnOpen event, I used:
Forms!frmSurvey.AllowEdits=False
Forms!frmSurvey.sfrmCount.Form.AllowEdits=False

When frmSurvey is open, I can still edit the record. However, if I click on a control in sfrmCount and then try to edit a control on frmSurvey then I can't make any edits. If I go to the next frmSurvey record, then I can again make edits until I click in sfrmCount.

How can I get both frmSurvey and sfrmCount to be read-only without having to click elsewhere on the form? Setting the form property AllowEdits to No didn't work either.
Thanks,
Charlotte

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums