OK, this is what I want to do:
I have a table of data. One of the fields is a combobox that populates itself from another table. I want to be able to create a report that prompts the user to select the data from combobox list, then display the query results.
I've read on the interwebs that in order to do this, I have to create a form that consists solely of the combobox, then get the query to run when the combobox is updated.
Here is the code that I've got in the form.
Code:
Private Sub Form_AfterUpdate()
stDocName = "qryCoater1MaintenanceSub"
DoCmd.OpenQuery stDocName, acNormal, acEdit
End Sub
So, is it possible to have the report call the form which then calls the query?
Does that make any sense?