Print contects of a listbox

D

DanRoy

I have a listbox on a form which I wish to print. Following suggestions for
textbox's, I created a report with the text box bound to the form's textbox
and added the DoCmd.OpenReport "reportname"

All I get is a blank box from the report. Can anyone provide suggestions for
me to check?
 
T

tkelley via AccessMonster.com

I may not fully understand, but why not set the report's recordsource to the
same as the listbox's rowsource?

Leave the report's recordsource empty, and set it at runtime:

On Open

me.recordsource=Forms![YourForm]![YourListbox].rowsource

Try that ...
 
Top