Ginger,
You could have an unbound textbox on a form where the macro is triggered
from, and the user can enter the name of the file name in there, and
then your Database Name argument can be the equivalent of...
="C:\YourFolder\" & [NameOfTheTextbox] & ".mdb"
On another topic... Do you mean there are 6 databases in each of the 43
offices? Can you say what is the difference between the 6 databases?
What you are doing is very unusual, and leads me to suspect that the
whole thing could be simplified.
--
Steve Schapel, Microsoft Access MVP
Please let me clarify. I am sorry I am not being clear, I am not very
experienced.
I have 43 field offices with 6 databases. Inside each database is 1 table I
want imported. So I want to repeat the field office name 5 times after it is
entered once.