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.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums