I would like to find out how to run a select query but have it run in the background and not be seen. I have a "Master Table" with 2000+ records in it, the query I made acts like a filter, taking information from text boxes on a form and uses a query that has criteria to filter the results.
This information is displayed on a normal query page when ran, but I also have a popup form that has multiple records configured, it looks a lot better and I can format this better than a traditional query.
Private Sub button_Click()
DoCmd.OpenQuery "FinderQuery"
Forms("MainMenu").Visible = False
DoCmd.OpenForm "PlotDetails"
End Sub
So Main Menu is where the search functionality is - FinderQuery is the filtered results - PlotDetails is the stuctured, nice looking multiple items form that is linked to FinderQuery.
Any ideas? Thanks