Print Selection In Button

  • Thread starter Thread starter Delker
  • Start date Start date
D

Delker

Hi,
First, thanks for your time! I have a form used for
entering new records and/or editing data in existing
records, and need a button at the bottom to print the
individual record in the form format. I'm familiar with
designating a macro to print, but it prints all records
rather than just the one selected. Is there a DoCmd of
some sort that may work??

Thanks,
Frank
 
See the Microsoft Knowledge Base article:

<http://support.microsoft.com/?id=209560>

for the preferred method of printing the current Record.

You can also create a Report that looks similar to the
Form. In the Forms Database Containers window, right-
click the relevant Form and select "Save As ..." and
choose "As Report", give it a name and your Report is done.

If you still want to print the Form, you need to use the
Menu File / Print ... and select "Selected Record(s)" in
the Print Range pane of the Print Dialog.

HTH
Van T. Dinh
MVP (Access)
 
I have a 'Print' button on most of my forms that uses the
following VBA code:

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.PrintOut acSelection

Shadow
 
Back
Top