Application screenupdating in access vba
I always assumed it was just used so that it didn't scare end users into thinking their PC was about to crash.
When I started reading more into improving the efficiency of your code I understood what it was for but how much of an effect does Turning off screen updating will only make a difference to execution time if the code interacts with Excel in a way that causes changes to the screen content.
Group='" & selectedgroup & "');" 'On Error Go To Error Handler With Active Sheet. Add(Connection:=s Conn Params, Destination:=Range("J1")) .