Help required with a Single Record Query

[thompjas]

Hi,

I have managed to set up a query that displays the current record in my dummy database using the ID number of the current record within my form using the following

[Forms]![CustomerForm]![ID]

so far all works and only one record is shown

Now I want to export the query data as an XML file when I export using the built in tools I get a pop up window asking for entering the parameter value - Forms!CustomerForm!ID

What am I doing wrong ??



I am working my way towards an automated XML output and a SetValue change (setValue part is working already...!)

[June7]

If the form is open, that prompt should not happen.

[thompjas]

So an undocumented feature !

[June7]

I don't know why this is happening in your db, just that it shouldn't. If you want to provide for analysis, follow instructions at bottom of my post.

[thompjas]

I have created a sample Database using the query that is in my larger database

to summarise - the query shows the customer name as defined in the 'open' form - I then want to export the queury to XML but I am asked to enter a parameter value - interestingly I am not prompted when exporting as a TXT file....


Any help gratefully received -

thanks

Jason

[June7]

The query is set up using Customer Name to filter records, not ID. I tested with both and don't get the popup input prompt. Export occurs without issue.


Recommend no spaces or special characters/punctuation (underscore is exception) in naming convention.

[thompjas]

Cheers, I have now amended all fields so no spaces, still get a prompt when I try an XML export !!

What am I missing...?

[June7]

I cannot replicate the issue with the db you posted.

[thompjas]

That's annoying ! and you can use the XML export function ?

[June7]

That's what I did. However, just tried again and now getting the issue!!!!! Cannot remember what I did before.

A solution appears to be described in http://bytes.com/topic/access/answer...eter-query-xml

It suggests using VBA command DoCmd.RunCommand acCmdExportXML

[thompjas]

Wahooo, looks as though you have found a solution to my issue !!

Thanks for your help !!