Enable/Disable Fields on a Form

L

LyndieBee

I have an initial drop-down list field on my form that requests a category
(Training, Support, General). There are three columns of fields below--one
column for each of the three categorys in the first field (the fields in
these columns are each relate back to the fields in a separate table). If,
for example, I choose "Training" from the drop-down list field, I want only
the training column of responses to be enabled, if I choose "Support" I want
only the fields in that column to be enabled. Can you give me some
suggestions on how I might accomplish this, please. Many thanks.
 
G

Gerald Stanley

One way of achieveing this is to put code in the list box's AfterUpdate
eventHandler to set each control's Enabled property as required . E.g.

Select Case lstCategory.Value
Case "Training"
txtTraining1.Enabled = True
txtSupport1.Enabled = False
txtGeneral1.Enabled = False
etc
Case "Support"
etc
Case "General"
etc
End Select

Hope This Helps
Gerald Stanley MCSD
 
Top