Choosing subform fields from master form

[sboegeman via AccessMonster.com]

Hello -

I have a master form with 4 subforms. 3 of the subforms have only checkboxes.
The boss wants to choose the checkboxes displayed in subforms. For example,
this week the boss wants users to view checkbox1, checkbox2, checkbox5, and
checkbox7 in a subform. The following week he wants users to see checkbox3,
checkbox4, checkbox6, and checkbox 8. I'd like the boss to have an
administrator console where he chooses what checkboxes will be available for
the users.How do I handle this with a multiuser split database?

Any ideas?

Thanks!

Steve

 

[Michel Walsh]

Have a table with two columns, one, CheckBoxName, String, for the checkbox
name, the second one, IsVisible, Boolean, for its availability.

On loading the form, check for each checkbox, in the said table, if it
should be visible, or not, and modify its visible property accordingly:


Me.CheckBox6.Visible = DLookup("IsVisible", "tableNameHere",
"CheckBoxName='CheckBox6' " )




Supply the boss with a form where he/she can change the said table, do not
supply (access to) that form to the other employee.



Hoping it may help,
Vanderghast, Access MVP

 

[sboegeman via AccessMonster.com]

Hi Michael -

Thank you for the help!!! I appreciate it. I'll try this ASAP.

Steve

Have a table with two columns, one, CheckBoxName, String, for the checkbox
name, the second one, IsVisible, Boolean, for its availability.

On loading the form, check for each checkbox, in the said table, if it
should be visible, or not, and modify its visible property accordingly:

Me.CheckBox6.Visible = DLookup("IsVisible", "tableNameHere",
"CheckBoxName='CheckBox6' " )

Supply the boss with a form where he/she can change the said table, do not
supply (access to) that form to the other employee.

Hoping it may help,
Vanderghast, Access MVP

Hello -

[quoted text clipped - 16 lines]

Steve