Export to CSV text values not list index values

[Jason Stein]

I'm trying to export a query to a CSV file, but when I export the query, the
various list index values are exported (from the form) and not the text
values which are displayed in the query.

The only way I can get the results I'm looking for is to select the table,
copy it, paste into Excel and save as a CSV.

I'm looking for a direct export out of Access 07 which can then be automated.

I was un-able to find my answer on the forum,, I apologize if this has been
answered already.

 

[AlanSidman via AccessMonster.com]

Jason, you will have to link your table that is used to look up the values in
your form from the list box. Once you do that, you should then insert the
field with the values and deselect the index values in your query.

Alan