Print single record as Form (not report)

pheidlauf

Registered User.
Local time
Today, 19:46
Joined
Jun 5, 2013
Messages
42
I need to find a way to print the currently selected record (by clicking a button in the form) as a form. I know printing is almost always done in records, but they use the forms by hand before entering them into the computer database.

One tough part of this is that this printing function needs to be sustainable through revisions of the form, as we will be constantly updating it.

Is there a way to print the form with only the current record shown without creating a second form or report? Thanks!
 
Hmm, try...

Code:
Dim myForm As Form
Dim PageNo As Integer
 
PageNo = Me.CurrentRecord
Set myForm = Screen.ActiveForm
 
DoCmd.SelectObject acForm, myForm.Name, True
DoCmd.PrintOut acPages, PageNo , PageNo , , 1
DoCmd.SelectObject acForm, myForm.Name, False
 

Users who are viewing this thread

Back
Top Bottom