Export Query to XML via an input prompt?

[briananderson]

Really don't want to double post, but I'm finding this is more of a query issue than anything.

I'm trying to export a filtered query to xml. I'm experimenting with filtering only one field:

WHERE ((([PART OUT - SET ITEMS].SETPURCHASEIDLK)=5));

Exporting to XML works just fine.

But if I try to filter it having the query ask for the user to input the criteria this way:

WHERE ((([PART OUT - SET ITEMS].SETPURCHASEIDLK)=[Insert ID Number]));

I am unable to export to xml and i get the following error message:

"Microsoft Access was unable to export the data"​

What am I doing wrong? Its driving me nuts trying to sort this out.:banghead: Any help would be appreciated.