
Using a main form to control the edit properties of a subform using VBA
I am trying to write some code that will allow me to
change the status on displayed controls on a subform. The
status (locked/enabled/disbaled etc) will be based on a
specific selection within an option group on the main form.
example: I am looking to control the status of multiple
objects (not necessarily all of them) on a subform based
on the option selected(EDIT or
VIEW) within the group of Options in the main form.
if VIEW is selected I want the identified controls on the
sub form
to be read only (Locked). if edit is selected I want the
controls to be editable (unlocked)
If possible I would like to reuse this code for other
subforms that are on also on the main form and controls
there status as well... so I imagaine I will need to write
this in a standard module.
Any help with this issue wil be greatly appreciated.
Regards, and thanks in advance for your help
Jer