refresh subform control

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

I would like to refresh a combobox list (AppointmentCodeID) on a subform and
have tried:

Me.frmProcList2.Form!AppointmentCodeID.Refresh
and
Me.frmProcList2.Form.AppointmentCodeID.Refresh

which produces error "invalid method". I also tried setting the focus to the
subform control before the refresh with no improvement. How can I do this?

Thanks so much!
 
according to Access Help, the Refresh method only applies to the Form
object. so you can't use it on a combobox control. suggest you try the
Requery method instead, as

Me.frmProcList2.Form.AppointmentCodeID.Requery

hth
 
Back
Top