Export XML Parameter Query

[Joshua A. Booker]

Hi There,

I am exporting a report using ExportXML method. I have found that if a
query has criteria which references a form, the parameter dialog appears.

Does anyone know a way around this?

TIA,
Josh

 

[Ron2006]

The query has been told to get the information, therefore....

Have the form open and the information loaded in the field that it
needs then run the query.

OR

Supply the information when the parameter dialog appears....


OR

Change the query not to require the information.


I believe that those are your only choices.

Ron

 

[Joshua A. Booker]

Thanks for your reply, but I'm not trying to avoid a parameter being
required. The report based on this query previews and prints fine without
the parameter dialog.

The form is open and info is in the field. The parameter dialog only
appears when I use the ExportXML method.

has anyone worked around this before. Does the ExportXML method use ADO or
DAO?

TIA,
Josh

 

[Ron2006]

Your answer says my simple response obviously doesn't cover the
situation.

hmm

Someone with more specific knowledge about the situation will have to
chime in now.

Ron