display query results in subform

[Rob Wells]

Hi.

I have a form with 5 buttons, each of which runs a slightly different query against the same table. I want to be able to display the query reults in a subform so that the user can click an view from the same screen. Any hep would be greatly appreciated.

[NeoPa]

You design the form that's to be used as the subform then, depending on how much needs to be changed between each version, you either change the RecordSource of the subform when you click a button (In the code behind the button), or you set/change the Filter instead.

[Rob Wells]

Thanks for replying. I think I might be overcomplicating this. All I want is for the results of the query to show up inside the form instead of as another tab in Access. They can remain in tabular format. I figured I would need to use a subform but perhaps there is another way? The catch is that I have 5 different queries. maybe a split form?

[NeoPa]

It seems a sub form is a perfectly appropriate way to proceed. In fact the suggestions I posted earlier seem to fit the bill more than adequately. I don't understand your current reservations.