I've got a database that has a form that needs to display the results of a query against another access database. Currently I do this by opening the other database running the query and then copy the results into the rowsource property of the list box, after clicking values. This works, however lately the query result got bigger and rowsource is limited to 2,000 characters.
What is the proper way of doing this? I'm assuming I'll need to link the foreign table but since the other database is user's choice I'll need to do this in code. Also I'll need to delete the link later.