Please Help!? Linking Option Groups and Combo Boxes!

A

A. Smart

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!
 
S

Sprinks

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
 
Top