Need help displaying results of one query in command button

[HydroPnik]

Hello all. Access 2003/Windows XP.

I have set up a command button where three queries are run. The first and last queries are select and the second is an update. I only want to display the results of the last query to the user. Can someone help me out? Here's the code.

Private Sub btn_Submit_Click()
On Error GoTo Err_btn_Submit_Click

Dim stDocName As String

stDocName = "qry_Submit1"
DoCmd.OpenQuery stDocName, acNormal, acEdit

DoCmd.SetWarnings False
stDocName = "qry_Submit2"
DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.SetWarnings True

stDocName = "qry_Submit"
DoCmd.OpenQuery stDocName, acNormal, acEdit

Exit_btn_Submit_Click:
Exit Sub

[HydroPnik]

I figured it out...if I didn't have the table opened when I clicked on the command button I wouldn't need the third select query. Duh!

[MMcCarthy]

I figured it out...if I didn't have the table opened when I clicked on the command button I wouldn't need the third select query. Duh!

It's always nice when posters figure these things out for themselves. :)

Mary