Using list box field for later use

[Guest]

I am new to Access and hopefully the answer to my question could be very
simple. Bascially, our clinic has a software program that creates aging files
in .dbf format. For example, Jun0.dbf, Jun30.dbf, Jun60.dbf, Jun90.dbf and
Jun120.dbf, that I import into Access, create one table using a union query
and then do further reports and queries using other tables. What I want to do
is create a form that prompts for the abbreviated month to use, I thought a
list box would work. Once the month is selected, I then want to concantanate
the abbreviation of the month with the aging periods, Month0,Month30, etc and
then run a macro to import the month selected. My question is how do I use
the field selected and concantanate it with the numbers for the aging periods?

 

[Guest]

Concatenate the date from the ListBox like --
[Forms]![YourFormName]![YourListBoxID] & ".dbf"

 

[Guest]

Thanks Karl, but I guess a more basic question is where do I put this
instruction?

Concatenate the date from the ListBox like --
[Forms]![YourFormName]![YourListBoxID] & ".dbf"

I am new to Access and hopefully the answer to my question could be very
simple. Bascially, our clinic has a software program that creates aging files
in .dbf format. For example, Jun0.dbf, Jun30.dbf, Jun60.dbf, Jun90.dbf and
Jun120.dbf, that I import into Access, create one table using a union query
and then do further reports and queries using other tables. What I want to do
is create a form that prompts for the abbreviated month to use, I thought a
list box would work. Once the month is selected, I then want to concantanate
the abbreviation of the month with the aging periods, Month0,Month30, etc and
then run a macro to import the month selected. My question is how do I use
the field selected and concantanate it with the numbers for the aging periods?

 

[Guest]

You said you were using a macro to import. Put it in your command line for
importing.

Thanks Karl, but I guess a more basic question is where do I put this
instruction?

Concatenate the date from the ListBox like --
[Forms]![YourFormName]![YourListBoxID] & ".dbf"

I am new to Access and hopefully the answer to my question could be very
simple. Bascially, our clinic has a software program that creates aging files
in .dbf format. For example, Jun0.dbf, Jun30.dbf, Jun60.dbf, Jun90.dbf and
Jun120.dbf, that I import into Access, create one table using a union query
and then do further reports and queries using other tables. What I want to do
is create a form that prompts for the abbreviated month to use, I thought a
list box would work. Once the month is selected, I then want to concantanate
the abbreviation of the month with the aging periods, Month0,Month30, etc and
then run a macro to import the month selected. My question is how do I use
the field selected and concantanate it with the numbers for the aging periods?