I have a file with location numbers, the company i work for has a differetn
location number than those.

here is the request, I need to take the original number and have it change
to our number, does this make sense.?

I tried the array, but it has a problem it guives some crazy numbers, not
the correct store #'s, this is basically find and replace, like the guy was
saying but it needs to be programatically,

Does the array need to be in numerical order (1,2,3,4...)?

can it hold more than 100 items?

should i put it in a command button?

"Guillermo" wrote in message
.. .
I have a file with location numbers, the company i work for has a differetn
location number than those.

here is the request, I need to take the original number and have it change
to our number, does this make sense.?