I don't want the code to keep running.
I want it to wait until all the records in the insert have been processed.
In another part of the app I need to insert the results of the query into a table as I use automation to get access to output a report as a snapshot based on criteria given at...
Im totally lost
Is there something I need to dp to pause my code from executing until my Insert query has finished
the following works - during Debug line by line or if I pop in a msgbox after it.
dont try to validate the Insert into statement - IT DOES WORK