Combo Box linked to query based on Option buttons

G

Guest

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?

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

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