After a little more testing,.. the original code is actully quite fast,.. my problem is the Tables are held on another Drive and the front end is on the desktop,.. connecting through the linked tables is causing the delay.

__________________
If i helped you, make me famous by clicking the