Combo Box linked to query based on Option buttons

I

I DONT KNOW

I have a combo box which links to a query that selects data based on a
choosen option button in a group. When the form is openned and you choose
Option A the combo box will return the correct data. When you choose Option B
it still has the same data from Option A. How do I refresh the data to the
combo box based on the option choosen in the group?
 
B

Bob Quintal

I have a combo box which links to a query that selects data based
on a choosen option button in a group. When the form is openned
and you choose Option A the combo box will return the correct
data. When you choose Option B it still has the same data from
Option A. How do I refresh the data to the combo box based on the
option choosen in the group?
Click to expand...

In the AfterUpdate Event of the Option Group:
me.combobox.requery <- change combobox to the name of the combo box
 
Top