Exporting the data from the form currently in the foreground

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm trying to export the data displayed in a form to an rtf file, by
clicking on a submit button on the form with the data I want exported. The
code for the button calls another module with the following code:

DoCmd.OutputTo acOutputForm, , acFormatRTF, FileName, True

The same happens with:

DoCmd.OutputTo acOutputForm, Form_Name, acFormatRTF, FileName, True

Is there an easy way of just exporting the data from a form that is
currently open?

Cheers,

Mike
 
Or perhaps instead of exporting the form to a rtf file, is it posible to
export the form's recordset? I know that for the form, there is only ever one
record in the recordset.

Cheers,

Mike
 
Back
Top