> cmdButton to Print 3 copies of record in Form view ?
cmdButton will print 1 but I need 3 copies of the one Form record.
If you are opening a report to print the current record, you can use the
following approach:
'***EXAMPLE START
Dim iCounter As Integer
For iCounter = 1 To 3
DoCmd.OpenReport "MyReport", , , "ID=" & Me.ID
Next
'***EXAMPLE END
I usually provide a textbox in which the user can type in the desired number of
copies (it always contains a "default" value) and retrieve that value for use in
the code.
If you are printing out the form (which I wouldn't normally recommend), you
could use the "PrintOut" method of the "DoCmd" object which has a "Copies"
parameter that will allow you to specify the number of copies. It is difficult,
however, to filter the printout to one record unless it will always fit on one
page.
--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.org (See the Access FAQ at
http://www.mvps.org/access)
NO Email Please. Keep all communications
within the newsgroups so that all might benefit.<<