Hi there I am displaying a some client note records on a form. When I filter the form for the client id I then want to save those records (notes) as a PDF. On the form I have a text box which displays info in the format (record 9 of 45), however when the form gets saved as PDF, every page comes out as record 1. It is not incrementing. Below is the code I am using to do this. Any advice on how to get it to increment when printing is much appreciated.
Private Sub Form_Current() With Me If RecordsetClone.RecordCount > 0 Then .RecordsetClone.MoveLast !txtRecordDisplay = “Note No. ” & .CurrentRecord & ” of ” & .RecordsetClone.RecordCount End With End Sub