refresh a contron from another control

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top