[AccessD] Control a subform's capabilities with outside procedures

Arthur Fuller fuller.artful at gmail.com
Tue Feb 26 11:05:00 CST 2008


I have a switchboard that contains a subform which contains the data the
user always wants to see. The form is set to allow neither edits nor
additions. Switchboard items are supposed to control that. The subform is
never open by itself, only as a subform on the switchboard. I'm having
trouble formulating the syntax. It's something like:

<code>
Sub Sites_AllowEdits()
    Forms("Switchboard") <reference to subform control and form associated
with it> .AllowEdits = True
End Sub
</code>

And similarly for the AllowAdditons procedure, except it will need a pair of
commands, one to AllowAdditions and the other to GoToNewRecord.

I always forget this syntax!

TIA,
Arthur



More information about the AccessD mailing list