help with updating a combo on a subform

[Guest]

I'm having trouble updating combo boxes on a subform I'm using the requery
method.
I want the list on the combo box in the subform to update when a combo box
on the main form is updated.

 

[Graham R Seach]

This should work:
Me!frsSubform.Form!cboMyCombo.Requery

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Guest]

just figured it out. thanks

This should work:
Me!frsSubform.Form!cboMyCombo.Requery

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Guest]

just sorted it out, so I'm going to answer my own question now.

I need to refer to the combo control in the subform correctly
e.g.
If you place the code module in the main form use the following syntax:

Me![Sub-form Name].Form![Control Name].Requery