I love the feature that Jim added a few weeks ago allowing a text list to automatically refresh when displaying data using the database navigator. It works great when the text list is displaying data in a form attached to the current database, but it is more tricky when displaying data from an external database. In my test case, I want to display sorted external data in a form attached to my Main database. To do that I SetActiveDatabase to the External database. Then sort the data before going back to my Main database. The question is how to I refresh the text list object to display the sorted data in the External database? I appreciate any help.
That is not possible, and not likely to ever be possible.
Not a problem. Just a little more work. The external database is not large. We will sort it and then display a variable via a Text List Object.