View Queried Data After Query Finished

[Rickinrsm]

I'm trying to figure out a way to automatically view the datasheet results of this query on top of, or within a single page form when the query is finished.

It must be a simple thing, right?

Option Compare Database
Option Explicit

Private Sub Command14_Click()

End Sub

Private Sub QueryForReports_Click()
On Error GoTo Err_QueryForReports_Click

    Dim stDocName As String

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

Exit_QueryForReports_Click:
    Exit Sub

Err_QueryForReports_Click:
    MsgBox Err.Description
    Resume Exit_QueryForReports_Click
    
End Sub

Rick ~ Access Newbie

 

[JerryKlmns]

Rickinrsm,

In design view of the form, drag and drop the query on the form. Every time you openm the form you shall see your query result... after it finishes running.

 

[Rickinrsm]

In Form design, Access will not let me drag any objects from the database window to the form? Not queries or other tables.

Any ideas . . . ?

Rick ~ Access Newbie

 

[JerryKlmns]

R U sure????????

I just did it and actual it was a parameter query and run perfectly!

How did you try to do it?

 

[Rickinrsm]

Jerry - Okay I was able to drag and drop the query onto the form. This does work.

But each time I run the form the query runs and shows the results.

What I'm really looking for is to run the code I have shown in my original post above and THEN show tthe resaults in a datasheet on top of the form.

Thanks . . .

Rick ~ Access Newbie