How to send one line to printer or report using VBA

[sklambert]

I am posting this in a few Access forums to see if anyone has ideas. I need help with printing. I am writing a procedure to read and update records in a table. I want to read a record, print the value of a field, change the value of the field, then print the value of the field again. I want to also add comments with the values. I want to send each line to the printer as the code is executed. Alternatively, I need to know how to send each line to a report, then print the report at the end of code execution.

So I want to do this in code:

With rst
.MoveFirst
Do While Not .EOF
.Edit
Send "VEHICLE NUMBER " & the value of rst![VEHICLE NUMBER] to printer
Change the value of rst![VEHICLE NUMBER]
Send "CHANGED TO " & the new value of rst![VEHICLE NUMBER] to printer
.Update
.MoveNext
Loop
End With

Please, any help would be greatly appreciated!!! Thanks in advance!!!