I'm not sure if this is the right forum to post this question but.

I have a table with particular data that I want to export to a comma delimited file. The parameter values may vary daily.

I have a query which utilizes parameters from a form tied to a table so the parameters are stored. I'm viewing the query from within this form as a subform and it's working great.

Now the problem. I want to take these query results and export to a .csv file. I've tried this code

, but it asks for the parameters already provided by the form. If I replace the query name with the name of the subform, I get this error.
Run-time error '3011'
The Microsoft Access database engine could not find the object 'subfrmSampleExport2'. Make sure the object exists and that you spell its name and the path name correctly.

Any ideas??

Try this.
Make the parameter query a make table query and then run your export from the created table. Then you wont need any parameters in the query you are using for the export to csv.

Sorry but the method sounds like a lot of work that results in storing duplicate data which bloats the database file requiring cleaning up afterwards to me?

I am sure there are easier ways...

1. Please post details of the Form, SubForm and Controls relevant to the Query and most important, the name of the SubFormControl that houses the "SubForm" [subfrmSampleExport2]. Please note that the name of the SubFormControl may be different from the name of the Form being used as the "Subform".

2. Please post the SQL String of the Query [qrySampleExport2]

To make it easier to understand, I've created an Access database with all the relevant tables, queries and forms.

The table "tblMain" will accumulate new data daily. I will be changing the parameters for the needed export data periodically.

Currently, I'm only working with the tblMain (Samples) not the Catalog data in case you are wondering about the additional parameters on the form.

I hope this helps.

Thanks.

This post has been edited by skwilliams: Jun 24 2011, 09:00 AM

I figured it out. I just added [Forms]![frmCatSamProcessing]! to the switch in the query.

Thanks to everyone for their assistance.

Incorrect reference to the Form Control in the Query was what I suspected and therefore I asked for the SQL String of the Query and details of the Form.

Glad you worked it out...