Please Help!? Linking Option Groups and Combo Boxes!

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

Guest

I would like to be able to select an option box which would activate a combo
box, from which a selection can be made. Much like the Northwind Sales Dialog
Box. I am having a little trouble! Please Help.
Cheers People!
 
Set the combo box' default Enabled property to No in form design view, and
enable it in the AfterUpdate event of the Option Group.

If Me!YourOptionGroup = YourSpecialValue Then
Me!YourComboBox.Enabled = True
End If

If your form is not a dialog form like the example you mention, but is bound
to a RecordSource, you will need to set the property in the form's OnCurrent
event:

If Me!YourOptionGroup = YourSpecialValue Then
Me!YourComboBox.Enabled = True
Else
Me!YourComboBox.Enabled = False
End If

Sprinks
 
Back
Top