It's working now. I created a new query and added Q_TransactionsDadReport2.
It's working now. I created a new query and added Q_TransactionsDadReport2.
June 7
Can you help me with post #12. I like your idea about using one form with multiple buttons to run reports. Not sure what would be the VBA for the Ok button.
Thank You
Different ways to approach this.
Can have a listbox of reports. User selects report in listbox. Code in listbox AfterUpdate event opens the selected report. If the text in the listbox is the exact report name, simply:
DoCmd.OpenReport Me.Listbox
Or can have individual button for each report.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.