Refreshing results displayed on the subform

[Flo100]

I have a subform that i created in a main form, which I am using to display results of a query. There are different controls on the main form that make a query. The subform, so has to display the related results. There is a button click event in which I am making the query. I donno how to refresh the subform so that it reflects the results of modified query.

Please help. Thank you.

[puppydogbuddy]

I have a subform that i created in a main form, which I am using to display results of a query. There are different controls on the main form that make a query. The subform, so has to display the related results. There is a button click event in which I am making the query. I donno how to refresh the subform so that it reflects the results of modified query.

Please help. Thank you.

If I understand you correctly (you did not provide your code):

in your button click event: after your sql string is created, you need to assign it to the record source of your subform as follows:

Me!YourSubformC ontrol.Form.Rec ordSource = strSql

[ajetrumpet]

Maybe you could try "Me.[subformname].Requery" on one of the subform's property events??
Or maybe "[Forms]![subformname].Requery" on the main form property events??

[abolos]

If I can understand you, in the button_click event add:

<subform>.reque ry