Hi there.

I have a query that should take the details from the current form, and write them to a csv. But the query is not taking the info from the form it is taking it from a table. So basically i am looking for it to take details from the record and not the table. Is there any SQL that would do this.

Thanks

Allan

Yes, you will always get the data from the table and not the form. You need to specify the relationship fields in your SQL statement, or in your code. For example:

"SELECT * FROM tblYourTable WHERE [ID] = " & YourID

This will limit the records in your results to those you see in the subform. In fact, that is how the subform limits its records.

Does this help?

mmcdonal

Yes, thanks a lot :D