Changing Subform Records with Combo Box in Main Form

[Steve D]

This seems like it should be easy and maybe it is just because it is Monday
but I am having an issue with a subform. I have an unbound combo box called
[cmbMonth] and a subform that pulls from a query which uses the value of
[cmbMonth] as its criteria. In the AfterUpdate property of the combo box I
have the following expression:
Me.[Month].Form![frmAssociatesPaidChargeback_View_Pct].Requery
but it does not update the subform. I am assuming this is not the correct
code to do this. Any help would be appreciated.

 

[Beetle]

If the combo box is on the main form, then it should be;

Me![NameOfYourSubformControl].Form.Requery

The name of the subform control is usually, but not necessarily, the same
as the name of the subform itself.

If the combo box is on the subform, then it should just be;

Me.Requery

 

[Steve D]

Perfect. Thank you.
--
Thank You,
Steve

If the combo box is on the main form, then it should be;

Me![NameOfYourSubformControl].Form.Requery

The name of the subform control is usually, but not necessarily, the same
as the name of the subform itself.

If the combo box is on the subform, then it should just be;

Me.Requery
--
_________

Sean Bailey

This seems like it should be easy and maybe it is just because it is Monday
but I am having an issue with a subform. I have an unbound combo box called
[cmbMonth] and a subform that pulls from a query which uses the value of
[cmbMonth] as its criteria. In the AfterUpdate property of the combo box I
have the following expression:
Me.[Month].Form![frmAssociatesPaidChargeback_View_Pct].Requery
but it does not update the subform. I am assuming this is not the correct
code to do this. Any help would be appreciated.