refresh a contron from another control

[Guest]

When I click on the f_markets control I want to refresh the cb_market control
on my form. But I get the error messgae 'object required ' .

What do I need to do to reference cb_Market correctly?

Bruce

Private Sub f_markets_Click()
a = [Forms]![frm_Prod_Fcst_Search]![cb_Market]
a.Refresh
End Sub

 

[Guest]

Try this instead

[Forms]![frm_Prod_Fcst_Search]![cb_Market].Requery

Other wise you have to declare "a" as a control, but there is no need to do
that, just use the above example