Question
Thread display: Collapse - |
All Answers
Share your knowledge
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Report Preview and Print Differ
If Not rst.BOF And Not rst.EOF Then
Me.txtInvestor = rst!Name & " " & rst! Surname
Me.txtStreet1 = rst!Street1
Me.txtCity = rst!City
Me.txtCtry = rst!Country
Me.txtCallAmt = CCur(Forms("Capital Calls")!txtPct) * CCur(rst!TotCommit)
rst.MoveNext
End If
When I press the command button that prompts the report, the preview shows me a two-page report with what appears to be correct data. However, when I actually print the report out all fields are set to data pertaining to the last record only.
Can anybody point what it is that I'm doing wrong or not doing? Thanks