1) I go out and read the data base name which will always include the
facility number IE-060002 Kansas, 060003 New York, etc.
2) I concatenate that name and use only facility number to make my new
table and append data to it IE-060002, 060003, etc.
3) This variable/table name is used all thru my program/sub routines.

Can you offer some help on coding this into my form?

The facility number is also part of the original table I start with. I
could search, find, and concatenate it to make my variable as well.

Currently I hard code the facility id in all locations of my code. I use
find/replace when I transfer the form from one mdb to another.

Thanks in advance.

C. Pete Straman

John Nurick [Microsoft Access MVP]-Looping through linked tables 3rd request