Does anybody know of a way to store the SQL query as a percistent object, in VBA, so that it can be reused later on in some other code?
If that's not possible, how can I initialise a RowSource property of the ListBox to the SQL query? (given that RowSourceType is set to Table/Query)???
Thanks a lot