Can you please walk me through "using DAO to modify the QueryDef"? Maybe an example of how you do this to run append queries from form references?
It's just strange that CurrentDB.Execute works with delete queries and not append queries.
I commented out lines in the codebuilder one by one to determine which were and weren't working, see comments in brackets below:
Private Sub ReportButton_Click()
Dim varItem As Variant
For Each varItem In Me.ReportList.ItemsSelected
CurrentDb.Execute...