Changing Subform Records with Combo Box in Main Form

  • Thread starter Thread starter Steve D
  • Start date Start date
S

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.
 
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
 
Perfect. Thank you.
--
Thank You,
Steve


Beetle said:
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


Steve D said:
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.
 
Back
Top