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!