Report data doesn't populate from Query, just opens query

[Jojojo]

Hi,

I have a Member Type Report set up. The Report opens MemberTypeForm - where the user selects that type of member they want as criteria via combo box. When the user clicks OK, the form opens the MemberType Query instead of populating that data into the Report.

This is the code I have in the Form's Event "OnClick"
Private Sub OK_Click()
Me.Visible = False
DoCmd.OpenQuery "MemberType Query", acViewNormal, acEdit
DoCmd.Close acForm, "MemberTypeForm"


End Sub

I know it's coded to open the Query when clicked, and I'm assuming it has to be in order for the query to Run, but then how do I get that query to run where the user can't see it, and have the data it produces show up in the report that the Member Type Report.

Thanks!

[pbaldy]

You open the report, not the query (DoCmd.OpenReport). The report will run the query in the background on its own.

[TheShabz]

As long as the query exists, opening the Report it is attached to will run the query. It need not be opened for this to happen. Just open the report and you should be set, assuming your query is properly written to take whatever you need from the form.

[Jojojo]

You open the report, not the query (DoCmd.OpenReport). The report will run the query in the background on its own.

Thanks! The OpenQuery vs OpenReport was the problem - but now I get a Runtime Error 2585 when I click ok.

This is the code I have in the report events - is the problem in here?:

Private Sub Report_Close()
DoCmd.Close acForm, "MemberTypeForm"
End Sub
Private Sub Report_Open(Cancel As Integer)
' Set public variable to true to indicate that the report
' is in the Open Event
bInReportOpenEvent = True

' Open MemberTypeForm
DoCmd.OpenForm "MemberTypeForm", , , , , acDialog

' Cancel Report if User Clicked the Cancel Button
If IsLoaded("MemberTypeForm") = False Then Cancel = True

' Set public variable to false to indicate that the
' Open event is completed
bInReportOpenEvent = False
End Sub

[boblarson]

Don't open the form from the report. Open the report from the form.

[Jojojo]

Thank you!