Display query result upon access form(Enabling popup property)

[aman]

Hi guys

I have an access form and on it there is a MI button . when the user click on the button then query opens up but my problem is query is displayed behind the access form. How can I display the query upon the form.

Private Sub MI_Click()
DoCmd.OpenQuery "qryCompleted", acViewNormal, acReadOnly
End Sub

 

[DJkarl]

Create a new datasheet view form and use your query as the recordsource. Set that forms PopUp property to true and open the form.