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

If you're doing this from the switchboard,

	Me.mySubform.form.AllowEdits = True

 
Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, February 26, 2008 9:05 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Control a subform's capabilities with outside
procedures

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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com