refresh subform control

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!
 
T

tina

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
 

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

Similar Threads

refresh/requery subform 2
PLEASE HELP: Refresh a subform 5
Update a combobox on another form 1
how to refresh a subform 2
Refresh Data in a subform 2
Subform Refresh Fails on Opening Form. Works Otherwise. 3
Refreshing a subform 2
Refresh calling form 7

Top