read-only settings for Access forms and subforms

By chocolatte2 ·
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:

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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums