Help to clear a combo box when a option button is selected.

[ducky]

I have set up two option buttons. When option button 1 is selected I need to make sure that the combo box located beside Option button 2 is cleared. In turn I need to make sure that if a value is selected from the combo box that option button 2 is selected.
Help me please!!

[cyberdwarf]

Hi ducky

First, a question..

Are your option buttons inside an option box?

Steve

[ducky]

Hi ducky

First, a question..

Are your option buttons inside an option box?

Steve

Yes they are in an option box.

[MMcCarthy]

I have set up two option buttons. When option button 1 is selected I need to make sure that the combo box located beside Option button 2 is cleared. In turn I need to make sure that if a value is selected from the combo box that option button 2 is selected.
Help me please!!

Assuming Option frame name as opt_frame1 and combobox name as combo0.

You will need an event on the option frame, so for this example I'm using the after update event.

   
Private Sub opt_frame1_AfterUpdate()
 
  Select Case opt_frame1
 
	Case 1 ' if 1 is selected
	  Me.Combo0 = Null 
 
	Case 2 'if 2 is selected
	  ' whatever you want to do here
 
  End Select
 
End Sub

You will need an event on the combobox, so for this example I'm also using the after update event.

   
Private Sub Combo0_AfterUpdate()
 
  Me.opt_frame1 = 2
 
End Sub

[ducky]

Thank you very much!! It worked.. :)

[MMcCarthy]

Thank you very much!! It worked.. :)

You're welcome.

[Hutch]

So i'm trying to use this coding but its not working. here is what i'm attempting...

i have a form based on a query i'm using to search previous records, i have two combo boxes i use to search data, after i run a update procedure of one combo box the information is displayed in text boxes. I use combo box "A" to search the records by name, and combo box "B" to search by number. i need each combo box to appear null after the update procedure runs. any thoughts?