Help with subform

[nelslynn]

On my main form I have three txt/cbo boxes that are used as critera for the subform The subform is toggled to display after I enter the final txt box. How do I get the subform to display this query of records. I have written a query that works great, just need to incorperate it into the subform and then the main form. In short, I need to requery after I change the values on the main form so the correct data displays on the subform.

 

[SteveA]

At the same time where you make the Subform Visible ie (Me.NameOfYourSubform.Visible = True), place the following code:

Me.NameOfYourSubform.Requery

HTH
SteveA