Print form & subform information

Hi

Is it possible to print a form with the subform? Then my next question
is, how do I attach 'Clear form' or 'Save form' and clear it ready to
be used again.

I have created an invoice as a form and subform, spending quite a bit
of time, and have found that when I create a command button with the
wizard, it will only print the main form and information on that, not
the subform at all. Is it possible to do this or do I have to create
it again as a report?

Also, any hints on how I could add code to this button to clear and
save the information, ready for a new invoice, once it has been printed
would be very much appreciated!

Thank you!

Kymmy


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

On Wed, 28 Apr 2004 06:53:24 -0500, kymmy
wrote:


Hi

Is it possible to print a form with the subform? Then my next question
is, how do I attach 'Clear form' or 'Save form' and clear it ready to
be used again.

I have created an invoice as a form and subform, spending quite a bit
of time, and have found that when I create a command button with the
wizard, it will only print the main form and information on that, not
the subform at all. Is it possible to do this or do I have to create
it again as a report?

Also, any hints on how I could add code to this button to clear and
save the information, ready for a new invoice, once it has been printed
would be very much appreciated!

Forms are best used for onscreen viewing, Reports for printing. You
can open a Form in design view and save it as a Report to save the
labor of recreating all the controls.

It sounds like you may be viewing an Access Form as just a way to
print data to paper. That's NOT what they're for - they are designed
to add data to a Table (or tables); printing that data is a separate
operation!

To "blank" the form, simply click the * icon on the navigation
buttons to move to a new record in the table.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public