Moving records to new forms

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hello,
In my data base i have a main form that displays records
and a form that i want to use to print off selected
records. My main form is not formatted well to print, but
it is set up to navigate through records. Is there a way
i can update my print form with the record that is
selected in my main form? The idea would be to hit a
print button on the main form to open the print form and
have the record updated.

Thanks,

Mark
 
Hello,
In my data base i have a main form that displays records
and a form that i want to use to print off selected
records. My main form is not formatted well to print, but
it is set up to navigate through records. Is there a way
i can update my print form with the record that is
selected in my main form? The idea would be to hit a
print button on the main form to open the print form and
have the record updated.
Click to expand...

Forms are optimized for onscreen use; they're not really suitable for
printing. Use a Report for printing instead (you can open your "print"
form in design mode and save it as a Report to avoid rebuilding it).
Base the Report on a query which references your data entry form's
unique ID as a criterion:

=Forms![YourFormName]![txtIDfield]

The Command Button wizard has an option to run a report. Just click
the magic-wand icon and add a button, selecting the "print a report"
option.
 
Back
Top