Programming issue with this Macro
  Home FAQ Contact Sign in
microsoft.public.access.modulesdaovba only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... modulesdaovba Profile…
 Up
Programming issue with this Macro         


Author: forest8
Date: Jan 28, 2010 21:46

Hi

I am trying to program a print command in my database.

I have created a form which has a tab control with 3 pages. The Tab Control
is named "Main". When I have this code in the Event Procedure, nothing prints
out. Can someone point me in the right direction in how to fix this please?

Private Sub_Print_Form_Click()
Me.Main = 0
DoCmd.PrintOut
Me.Main = 1
DoCmd.PrintOut
Me.Main = 2
DoCmd.PrintOut
End Sub

Thank you in advance.
1 Comment
RE: Programming issue with this Macro         


Author: Lynn Trapp
Date: Jan 28, 2010 21:58

First, I'm not sure why you want to print a form, but the problem may be in
the name of your procedure. Try changing it to:

Private Sub Print_Form_Click()

--
Lynn Trapp
MCP, MOS, MCAS

"forest8" wrote:
Show full article (0.71Kb)
no comments