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