How to grey out controls

[Emma35]

Hi All,


I need help again but hey what's new . I have a data input form and the first item to be filled in by the user is a combo box (cboSelect) which contains two options. I want the form to work so that if the user picks say 'Option A' from the combo box then 3 or 4 other controls will be greyed out as they would become irrelevant for that option. Would anyone be familiar with the code to make this possible ?. The controls i would like to be greyed out are called


cboPlant
txtDay
txtShift
txtArea

Thanks in advance,
Em

[amrut]

Following code disables a control

Me.ControlName.Enabled=False

You will need to build the logic to enable/disable it based on user selection

[Emma35]

Thanks for the reply, but building that logic is way above my head unfortunately

[amrut]

Give it a try something like -

If Me.cboSelect="A" then
Me.ControlName1.Enabled=False
Me.ControlName2.Enabled=False
Me.ControlName3.Enabled=False
Else
Me.ControlName1.Enabled=True
Me.ControlName2.Enabled=True
Me.ControlName3.Enabled=True
EndIf

[Emma35]

Wow it actually worked first time !. Thanks a lot for your help....it's much appreciated

Emma x

[Missinglinq]

Note that in addition to having your code in the AfterUpdate event of the Combobox, you'll need it in the Form_Current event, as well, so that the formatting is record-appropriate as you move from record-to-record.

Linq ;0)>