User entered filename for ExportXML?

[nhabegger]

When the user clicks a button on a form, I am running the following:

  Application.ExportXML _
    ObjectType:=acExportTable, _
    DataSource:="tblXMLExport", _
    DataTarget:="C:\dir\subdir\filename.xml"

I want to ask the user to define "filename" before I run Application.ExportXML. How would you recommend I do this? Can I concatenate into the DataTarget parameter? Thanks!

[HiTechCoach]

I usually place a text box on the form and call the standard Windows browse dialog.

For code that you can easily add to your database see:

Proximity Functions