Requery a subform based on Combo Box

  • Thread starter Thread starter James C.
  • Start date Start date
J

James C.

Can someone help explain why this won't work.

I have a bound form tied to a query. On this form I have a combo box for the
user to select the criteria. I am using an After Update event in so that the
user selects the criteria from the drop-down and it simply requeries the
form. I am getting an error as it says the .Requery method or data member not
found

Here is my code

Private Sub Combo45_AfterUpdate()

Me.sub_Summary.requery

End Sub

Any ideas?
 
try adding the parentform in your requery statement so like this:

forms!Mainformname!sub_Summary.requery

where mainformname is the name of the main form as you have named it.

hth
 
Back
Top