I am trying to do a simple update query for a linked SQL database, but have it change databases based on what was selected on a form. There are many databases for the same tables - just different data. For example: A user clicks a database on a form - that will change the linked SQL database to that database (and if you hover over the linked SQL tables you can see the database has changed). But, when I go to run the query that has the table I want updated it shows the default database.
Database is set to (current) on the Query.
Thank you for your help!
Database is set to (current) on the Query.
Thank you for your help!