Export Query and Form Parameter

[techsponge]

I am attempting to export an Access Query as a text file. The query parameters are defined by a form that has a primary key which is an autonumber [PK11] The choice of Sales Order Number defines the query result set.

In the [Sales Order] parameter in the query, i have [Forms]![frmSalesForm]![PK11], I am prompted to enter a sales order number and the query runs fine within Access.

I then try to launch the query using:

DoCmd.TransferText acExportDelim, "AIMEXPORT", "PULLTABEXPORT", Me.txtDir, False

I get a parameter error!!! If I change the parameter to a set Sales Order - the process runs fine!!!

Any ideas or any thoughts?

 

[PWise]

is the form open when you run the docmd

 

[techsponge]

Yes I do. I am launching from a cmdButton on the sales form. If I hard code a sales number in the query, the file exports great from the button.

Thanks