acFormatXLS provides no data

[Callahan]

With Access 2010, has anyone ever tried to export a form to Excel using
a VB command like:

DoCmd.OutputTo acForm, My.[FrmNam], acFormatXLS, xlsnam, False, "", -1

My result is a spreadsheet with field names, but no data. Wonder what the funny fix will be. Could be like the one I found for a problem sending form filters to a report. The solution (found by accident) was to close the report before opening it. That's closing an unopened report. Funny, but it works.

 

[Callahan]

Access 2010 treats forms differently than it did with the 2003 version. Could not make acFormatXLS work with a form, however the query that the form is based on worked ok with it. Funny, heh, heh, yuk.