Code a button

[Grant]

Can I add/code a button on my form that will print only the selected record?

Thanks
Grant Dayton

[Trevor Best]

Grant wrote:

Can I add/code a button on my form that will print only the selected record?

Yes.
;-)

[Trevor Best]

Grant wrote:

Can I add/code a button on my form that will print only the selected record?

(air code)
Sub cmdPrint2ndRecord_Click()
Dim strBookMark as string
If Me.Dirty Then
Msgbox "Sorry, you have to save or abandon the current record first"
Else
strBookmark = Me.bookmark ' save current pos
With Me.RecordsetClone
.MoveFirst ' go to first rec
.Movenext ' go to second rec
Me.Bookmark = .Bookmark ' sync form
' insert print code here [1]
End With
Me.Bookmark = strBookmark ' return to where we was
End if
End Sub

[1] Sorry, I get stuck with the simple things, I assume you know how to
do that bit or else use the command button wizard to print the form and
copy the line of code out of that.

[Albert D. Kallal]

yes, you can use:
Me.Refresh

docmd.OpenReport "yourREport",acViewPreview,,"id = " & me.ID
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.attcanada.net/~kallal.msn

[Trevor Best]

Trevor Best wrote:

Grant wrote:

Can I add/code a button on my form that will print only the selected
record?

Sorry, misread, thought it said "second" record. D'oh!