If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Assign Form Controls to a Group
I am working with a form that has some client-specific fields. Client X has
three bound controls, a,b and c. Client Y has two bound controls, e and f. Right now, I show or hide the controls with an OnCurrent event. If Me.txtClient = "X" Then Me.cboStatus.Visible = True me.lblStatus.Visible = True 'etc. Else Me.cboStatus.Visible = False me.lblStatus.Visible = False 'etc. End If Can I group controls a,b and c? I imagine it would looks something like this: If Me.txtClient = "X" Then ClientX.Visible = True Else ClientX.Visible = False End If Where ClientX represents all controls associated with that specific client. Can this be done? If not, any suggestions to streamline the process? I have about 10 clients that all require specific fields. To reduce confusion, I only want fields relevant to a client to be shown. Thanks! PJ |
Thread Tools | |
Display Modes | |
|
|