Choosing subform fields from master form

  • Thread starter Thread starter sboegeman via AccessMonster.com
  • Start date Start date
S

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
 
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
 
Hi Michael -

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

Steve

Michel said:
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 -
Click to expand...
[quoted text clipped - 16 lines]
Steve
Click to expand...
Click to expand...
 
Back
Top