Set Subform property from modules (1 Viewer)

mstres

Registered User.
Local time
Yesterday, 18:47
Joined
Mar 18, 2009
Messages
24
How I set Subform property as AllowEdits from modules?
Thank you
Mike
 

boblarson

Smeghead
Local time
Yesterday, 18:47
Joined
Jan 12, 2001
Messages
32,059
Forms!YourMainFormName.YourSubformCONTAINER.Form.AllowEdits = True

Where YourSubformCONTAINER is the name of the control on the main form that houses the subform. If it is the same name as the subform that is okay, but if it is not you need to use the container name and not the subform name.

Also, you need the .Form. part in there to tell Access you are wanting a property or method of the subform itself and not of the subform container.
 

mstres

Registered User.
Local time
Yesterday, 18:47
Joined
Mar 18, 2009
Messages
24
Thank you,
I did try it is work.
It is realy help
Mike
 

Users who are viewing this thread

Top Bottom