Need to print 1 record

[webjunk]

I have a form that displays records one by one. I put in a Print button but it prints all of the records to a Report at once. I want it to print one record at a time. Help

Thanks [sig][/sig]

 

[Guest_imported]

This will get you going I think.

Dim stDocName As String
Dim strFilter As String
strFilter = "[KeyID]=" & Me.KeyID

stDocName = "Report1"
DoCmd.OpenReport stDocName, acPreview, , strFilter

Replace the KeyID part of this example with your linking field.
By using the acPreview you can view the results.

Let us know if this works!

John [sig]<p>John A. Gilman<br><a href=mailto:gms@uslink.net>gms@uslink.net</a><br>[/sig]

 

[kctaylordotcodotuk]

Or if you don't want to preview use

DoCmd.PrintOut acSelection [sig]<p>Keith C Taylor<br><a href=mailto:TekTips@kctaylor.co.uk>TekTips@kctaylor.co.uk</a><br><a href=

http://www.kctaylor.co.uk>The

Information Gardener</a><br>The C stands for Computer![/sig]

 

[parsok]

I'm new to using Access. How do you know and where can you find your &quot;linking field&quot;?