Admin Settings form

[accessbro]

I have a main form called frm_Main. It has a few controls including a button that opens a form called frm_Admin. The purpose of the admin form is to let the user choose between two modes, development and production. If the user chooses development, different controls will be set to visible on frm_Main and if it's set to production, other forms will be visible and the controls for development settings will be hidden. How can I set this up?



I was thinking about creating a table called tbl_Admin. It would have two fields, "mode" and "active". Then I would have two records in the table, one called "Dev" and the other one called "Prod". The active field would be true/false for both of them. tbl_Admin would be the record source for frm_Admin. frm_Admin would have a combobox with two choices for "Development" and "Production". Based on the user's choice, the records in tbl_Admin would be updated so that only one of "Dev" or "Prod" are set to true while the other one is false.

I'm not sure if I'm headed in the right direction. Does anyone have any ideas or input?

[ssanfu]

Seems kinda complex to me.

Could try:
Each control has a TAG property.
The controls for development can have "Dev" in the TAG property.
The controls for production can have "Prod" in the TAG property.
When the admin form opens, code can run to look at the button on frm_Main to determine which controls should be visible. The code would then set the visible property of each control.

Loop through the controls collection, checking the TAG property.

'Air code!!!

.
.
.
  Select Case ControlTag  'ie the TAG property
     Case "Dev"
         ' set visible to TRUE
     Case "Prod"
         ' Set visible to True
     Case Else
         'Who cares
  End Select
.
.
.