opening a query as a subform

[shrysh]

i've placed a query as a subform and an action button to run the said query. whenever i click the ' run query' button, it opens another tab and shows the query. i want the query to get updated in the subform itself. pl help

[jforbes]

The Wizard only creates a button to show you a query. It's not context sensitive and doesn't really know what you are doing or attempting to do.

You'll want to edit the button and replace the code that looks like this:

    Dim stDocName As String
 
    stDocName = "TheQueryYouWantToRefresh"
    DoCmd.OpenQuery stDocName, acNormal, acEdit

With something like this:

    Me.TheNameOfTheSubForm.Requery

[zmbd]

shrysh:
which version of Access are you using?
The control wizards starting in ACC2010 started using the Macro script language by design. To use J's code you will have to convert the control over to VBA.

[shrysh]

thanks for your replies,

I'm using access 13, i found a way of doing it using inbuilt macros.
1. open form in design mode and select a button.
2. choose create macro and asign it the property 'requery' and leave the rest field blank. not to be confused with the 'refresh' option available.
3. open in form view and clicking on the button requeries all the open queries thus refreshing the subform already open.