How to place query results on the same form - ACCESS 2007

[loneman]

Hi, I have created a form and the header I have a text box with a command button. When user enters text (supplier name) the command button should run a query taking as the supplier name as the parameter and show data belongs to the supplier in a data view. I got this working but when I click the command button Access 2007 opens up a the query in a different tab. How can I add the resulting data view to the same form in the detail section of the form.

Any help would be appreciated.

[TheShabz]

create a subform based off of the SELECT query you have stored. Have your command button, in VBA, do Me.subformName.Requery

that should take care of it.

[loneman]

Hi Court, thank you for the reply.

I added the VBA code but I won’t see the data in the sub Form.

Here is what I have in the main form (name) FSupplier

In the header section:
textbox: txtSupplier
commandButton: cmdSearch

In the Details Section:
I have the Sub form: SubForm this is based on the query QSupplier

I have a query call QSupplier with the criteria as [Forms]![FSupplier].[txtSupplier]

I added the commandButton eventProcedure in VBA..as follows.

Private Sub cmdSearch_Click()
Me.SubForm.Requery
End Sub

What am I doing wrong here?

[TheShabz]

They criteria in the query should be
[Forms]![FSupplier]![txtSupplier]