June7
AWF VIP
- Local time
- Yesterday, 18:57
- Joined
- Mar 9, 2014
- Messages
- 5,488
Options:
Build a form where user can select filter criteria and VBA can modify query object or query can have dynamic parameters referencing form controls or VBA builds SQL statement for INSERT SELECT action. Review http://allenbrowne.com/ser-62.html
or
Export report with DoCmd.OutputTo command.
or
There is possibly a way to reference report's RecordSource or Recordset properties and save data to table, but I've never done it.
Build a form where user can select filter criteria and VBA can modify query object or query can have dynamic parameters referencing form controls or VBA builds SQL statement for INSERT SELECT action. Review http://allenbrowne.com/ser-62.html
or
Export report with DoCmd.OutputTo command.
or
There is possibly a way to reference report's RecordSource or Recordset properties and save data to table, but I've never done it.
Last edited: