How do I update the combo box result in a sub form?

[TCS222]

A have a query feeding into a combo box on a sub form. When the main form record changes, the result of the combo box in the subform doesn't update. If I run the query itself, it does update. How do I get the combo box in the subform to update automatically when the record in the main form changes? Many thanks for any advice. (Access 2007)

[msoffice.vidyarthi]

You can try to update the list of the combo box in the 'enter' event of the sub-form

[TCS222]

Thank you. I put refresh in the on current event of the subform and it works - you're a star!

[msoffice.vidyarthi]

Could you click the star below my post for reputation