export to xml problems

[tinoco]

Hi!
i have a strange problem. I want to export a query to xml. I use the following expression for that:
Application.ExportXML acExportQuery, "queryname", "location"
This query needs information from a form. So it should read it from the form automaticaly when the form is open.
In some forms i can make the export and everything work in others the query ask me again the information.

Everything is made in the same way, i just change the query name.
Anyone have an idea about why this happen?
thanks

 

[nickspace]

Hi tinoco,
I am encountering the same problem. Were you able to figure out a solution?

Thanks,
ND

 

[tinoco]

Hi!
I solve the problem like:
i define the main query as a make table query, so every time that the query perform i have a table with the data that i want and than i export from the table instead from the query;
before you run the main query you need to create two macros, one to delete the table that your query made and the other to run the query again to have a table with a actualize data.

hope this helps