TransferText Problem

[jschmidt]

Hello Everyone,

Right now I have a macro set up to use a parameterized query with a transferText function. So when the user clicks on a button on the form they are prompted to enter a Stocking section. When they enter the section they would like and click ok, a csv file is generated for them.

Is there some way to have the user make a selection from a list box and click the export button and have the parameter automatically filled in for them using their selection from the list box and have that data exported?

Thanks.

[ADezii]

Hello Everyone,

Right now I have a macro set up to use a parameterized query with a transferText function. So when the user clicks on a button on the form they are prompted to enter a Stocking section. When they enter the section they would like and click ok, a csv file is generated for them.

Is there some way to have the user make a selection from a list box and click the export button and have the parameter automatically filled in for them using their selection from the list box and have that data exported?

Thanks.

1. Replace the actual Parameter in the Criteria Row of the Query with the Absolute Path to a List Box on your Form as in:
   [CODE=vb]Forms![Your Form]![List Box Name][/CODE]
2. In the AfterUpdate() Event of the List Box, run the TransferText Method.