Query results in subform

[MWMike]

Hi all,

I have a form with a combo box whose values I use as the criteria for a query. I also have a command button that runs the query. I want to display the query results in a subform datasheet (see attached picture).

However, when I click the button, the query runs and opens the results in a separate query datasheet, and doesn't update my subform.



To run the query when I click the button I used the "command button" wizard and set the action to "run query". I have the subform "source object" set to the query. I am probably missing some code somewhere, but I am still new, and have been sticking to the macros as much as possible.

Thanks for the help

[pbaldy]

Rather than run a query, you want to requery the subform. You can probably use a macro, or in VBA code:

Me.SubformControlName.Requery

[MWMike]

Rather than run a query, you want to requery the subform. You can probably use a macro, or in VBA code:

Me.SubformControlName.Requery

Hi, thanks for the reply.

I can't seem to find a macro for that in the options that come up for "action". I have yet to start playing around with the VBA code. Where do I put it? I tried putting it in the _Click() statement for the button but it didn't do anything.

[MWMike]

I still have the subform "source object" set to the query I was running before. Without the "run query" action of the button, I don't see how this works

[MWMike]

Sorry! should have spent more time playing around with it. It works fine! I guess I had some old buttons that I deleted whose code still showed up in the VBA editor. The names were similar so I put the code in the wrong place.

Thanks!

[pbaldy]

Ah good, glad you got it working.