Run query from a form and query opens

[cmathews]

I am new to Access so I apologize for the dumb question in advance. I have researched on the web but still can not figure out what I am doing wrong,


I have a form with a subform. I have a text box where I enter a value the click a command button to run a query and return the results in the subform. It works fine except that it opens the query results in a separate tab in addition to showing the results in the subform.
How can I get it not to open the query results in the separate tab?

Thank you

[June7]

Need to post your code so we can analyze and suggest changes.

[cmathews]

Here is my subform in design view


This is my code for the command button click

Private Sub Command2_Click()
DoCmd.OpenQuery "SuperValu Query"
Me!MySubForm.Requery
End Sub

[June7]

Remove the OpenQuery line. Delete it.

[cmathews]

Remove the OpenQuery line. Delete it.

Thank you, that worked!