Update open form after linking to a new backend database (1 Viewer)

[gemma-the-husky]

as I said - I think it is quite strange to want to switch databases with a form open in the first place.

I would be inclined to add code to prevent switching while forms are open.

 

[JHB]

So, full circle back to closing and opening the form :banghead:

The closing and opening form can also be done from code, nearly without any can recognize it, if you put in a DoCmd.Echo False/True.