Printing the active record only

[aligahk06]

Dear All,


I've designed a form and embed a command button called print record .
when i click the print record command button it is printing almost so many pages.I want to print only active record i.e say ( Record 2 to 2) contents only.

Any idea to accomplish this ?

Rgds,
Aligahk06

[maximus]

You need to let acces know what data to print. Take the example here. I would Like to print Report tblStudent for a particular Student ID which is in TEXT13 a control on my form.

The strCriteria seperates the Record

Dim stDocName As String
strCriteria = "[StudentID]=" & Me.Text13
stDocName = "tblStudent"
DoCmd.OpenReport stDocName, acNormal, , strCriteria

if this solves your problem mark the thread solved

[weekend00]

select one row then print the selection:

Me.SelHeight = 0 ' cancel selection
Me.SelHeight = 1 'select current row
DoCmd.PrintOut acSelection ' print selection

[Access_Blaster]

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