Issue Refreshing/Requery Subform/combo box

[Manuel]

Hi:

I need to be able to refresh or requery (not sure which method is
appropriate) a subform and combo box in the After Update event or via a
command button. I've used the below syntax but the combo box (in this case)
does not get updated.

Forms![MainForm]![sfrm_ResourceAllocation].Form![EmployeeID].Requery

Thanks,

Manuel

 

[Marshall Barton]

I need to be able to refresh or requery (not sure which method is
appropriate) a subform and combo box in the After Update event or via a
command button. I've used the below syntax but the combo box (in this case)
does not get updated.

Forms![MainForm]![sfrm_ResourceAllocation].Form![EmployeeID].Requery

Assuming the main form, subform control and combo box names
are correct, that should work. Be sure to double check that
you are using the subform **control** name and not the
subform object name.