change toggle on entry in combobox

P

p-rat

I have a form with a frame (two radio buttons - 1 = "non-dispose" and
2 = "dispose"). The default is set to 1. What I would like is for the
end user to tab past this frame and upon a selection in a combo box
(disposal site) the frame would automatically toggel to 2. If the end
user tabs through the combo box without making a selection then it
works because of the default.

Is there some code I could put in the combo box event? Thanks for any
help given.
 
M

Marshall Barton

p-rat said:
I have a form with a frame (two radio buttons - 1 = "non-dispose" and
2 = "dispose"). The default is set to 1. What I would like is for the
end user to tab past this frame and upon a selection in a combo box
(disposal site) the frame would automatically toggel to 2. If the end
user tabs through the combo box without making a selection then it
works because of the default.

Is there some code I could put in the combo box event?


Try using something like this in the combo box's AfterUpdate
event:

If IsNull(Me.thecombobox) Then
Me.theframe = 1
Else
Me.theframe = 2
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top