Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Question Unanswered: Controlling combo box display and option button

    Somebody please help me regarding on how to control the display of combo box from the series of option button. The condition is when the user click the option button the display in combo box varies depending on the user's choice and save it to the table.

    I'm just a new girl in town!!! Please assist me on my problem

  2. #2
    Join Date
    Nov 2003
    You will need to be a little more specific.

    I'm assuming that your ComboBox is bound to a table field and your option buttons are contained within a Option Group....

    Dim VariItem As Variant
    Select Case Me.myOptionButtonGroup.Value
       Case 0   'Option button 1
    	   VariItem = whatever...
       Case 1   'Option button 2
    	   VariItem = whatever...
    End Select
    If Not IsNull(VariItem) Then
       Me.MyComboBox = VariItem
    End If

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts