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 ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top