View Single Post
  #2  
Old September 6th, 2007, 08:30 PM posted to microsoft.public.access.forms
Maurice
external usenet poster
 
Posts: 1,585
Default Assign Form Controls to a Group

Let me see if I get this right. You have controls designated to clients?
(textfields). In that case I assume that controls 1 and 2 and 3 belong to the
first client etc. If so you might think of using the tag as a place to put
the clients name and then refer to that via code. Something like:

dim ctl as control
for each ctl in me
if ctl.tag ="ClientX" then
ctl.visible=true
else
ctl.visible=false
end if
next

Or do you mean something else?

hth

--
Maurice Ausum


"PJFry" wrote:

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