How do I make a form object's properties dependent on another obj.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to build an Access 2003 form where a combo box is enabled if a
specific value is selected in the option group that immediately precedes the
combo box in the tab order, but is disabled if that value is NOT selected in
the option group. Does anyone know how to do this easily?
 
Hi, Bill.

Sure. In the AfterUpdate event of the combo box and the OnCurrent event of
the form,

If Me!MyOptionGroup = CertainValue Then
Me!MyComboBox.Enabled = True
Else
Me!MyComboBox.Enabled = False
End If
 
Works great! Thanks a million!

Sprinks said:
Hi, Bill.

Sure. In the AfterUpdate event of the combo box and the OnCurrent event of
the form,

If Me!MyOptionGroup = CertainValue Then
Me!MyComboBox.Enabled = True
Else
Me!MyComboBox.Enabled = False
End If
Click to expand...
 
Back
Top