SO, please confirm my understanding here. If I am following the logic as you describe it, the functionalty you need is:

A. Read a bunch of part numbers from an array.

B. Retreive the rest of the information about each part read from the array FROM the Access Database.

C. Load the Part Number and Part Description into Separate arrays Test1 and Test2.

Did I miss a step here?

If not, then it seems like you While . . . Loop is redundant.

Please confirm my understanding of the logic here, and I think I can cobble together a solution . . .