How run query in the background

[JavaToPerlNowVB]

Hi Everyone

I have this code in a form, and I want to run few queries before the report grab data from those queries. I am not sure, if i should do docmd.openquery "queryName" but this way the query will open for the user and i don't want that to happen.

Private Sub workDonePoles_Click()
On Error GoTo Err_workDonePoles_Click
Dim stDocName As String
Dim stLinkCriteria As String
'Run Query here
DoCmd.Echo True, "Preparing Report...Please Wait"
stDocName = "completedWorkPole"
DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria

Exit_workDonePoles_Click:
    Exit Sub

Err_workDonePoles_Click:
    MsgBox Err.Description
    Resume Exit_workDonePoles_Click
End Sub

Thanks alot

 

[flyover789]

what type of queries do you want to run before opening the report? most probably update queries, no?
you can run update queries through code via

docmd.openquery "myupdatequery"

and the user qon't notice anything of it ...

HTH,
fly

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Database_Systems and _Applications shared across all Business_Areas[/blue]