Update/Refresh a subforms data
Posted on 2003-03-20
I have a form, Form1 with a subform, SubformGAP. SubformGAP's control is a query whose criteria comes from text boxes on Form1. SubformGAP is a datasheet form.
Here is what I would like to happen.
When I click a button "Refresh" on Form1, the SubformGAP query is run and the data that appears in the subform is refreshed.
I'm not sure how to make this happen. I've built a button that runs the query for SubformGAP, but all it does is open the query on top of Form1. Rather than have the query open, I want the datasheet in the subform to display the new data.
Hope this explination is at least a little bit clear. Thanks in advance for your help!!