Exporting Forms

L

Lisha

I have a form created w/ over 280 records. I want to export a single record
into Excel exactly how I have the layout in my form. How do I do that?
Suggestions would be greatly appreciated.
 
J

Jeff Boyce

Lisha

Forms, in Access, are screen displays of data. Excel stores data in cells.
I don't see how these are compatible.

If you'd like to send the data that's displayed in your form/screen, you
could do that by exporting the query that your form uses -- this would
export all data your form would display. You might need to limit it to the
specific record your form is displaying. You can do this in a query by
using the parameter/Criteria.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top