How to open queries in subforms?

[helpmeplease213]

Hello,

I have four different queries based on the same table. I would like to open them in a subform using four different button clicks (each query has its own button). How can this be accomplished?

I tried but it doesn't work could I please get an overview of how it can be done?

[CODE=vb]Private Sub Cmd9_Click()
data_window.Vis ible = True
data_window.Sou rceObject = "RECENT RECORD"
Label7.Visible = False
Label8.Visible = False
End Sub[/CODE]

[nico5038]

Why not use a tab control and place for each query a subform on a tab.
The tabs will work as "buttons".

Nic;o)

[Jim Doherty]

Hello,

I have four different queries based on the same table. I would like to open them in a subform using four different button clicks (each query has its own button). How can this be accomplished?

I tried but it doesn't work could I please get an overview of how it can be done?

[CODE=vb]Private Sub Cmd9_Click()
data_window.Vis ible = True
data_window.Sou rceObject = "RECENT RECORD"
Label7.Visible = False
Label8.Visible = False
End Sub[/CODE]

I have answered this already! this is double posted at this location

http://www.thescripts.com/forum/thread717885.html

Jim