How to: print out a FORM with only the one active record

[Martin \(Martin Lee\)]

I create a button in a FORM with VBA as:

DoCmd.PrintOut

However, it will print out as many as all the existing records

I want it to print out a FORM only with current record. How to modify the
VBA?

Thanks!

Martin
2008-02-14

 

[Albert D. Kallal]

I create a button in a FORM with VBA as:

DoCmd.PrintOut

However, it will print out as many as all the existing records

I want it to print out a FORM only with current record. How to modify the
VBA?

The recommended approach here is to design and layout of report that looks
like your form, for the most part when you attempt to print things you have
all kinds additional difficulties such as the background for shading of the
form eccentric, user report to print out.

The code to send the ONE record to the report is:

me.Refresh
docmd.OpenReport "nameofReprot",,,"id = " & me!id

The me.refresh forces a disk write (so the report can see any changes), and
the open report has a "where" clause that restricts the record to the
current primary key (usually id in most cases).

 

[Allen Browne]

See:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html