Passing the contents of a listbox from a form into a report

[tonygg]

That's strange. Is it possible you could send me the code you used in the form to launch the report in preview mode? I have attached the screenshot of what you should see on the report and form with Batches 1 to 5 open. Thank you so much for taking the time to look.



Tony

[tonygg]

Hi. I have tried again and if I use my sub that already exists in the form to launch the report:

Private Sub PrintOutRecSheet_Click()

If Application.CurrentProject.AllReports("LUCY BARCLAY RECON REPORT").IsLoaded = True Then

DoCmd.Close acReport, "LUCY BARCLAY RECON REPORT"
Else
DoCmd.OpenReport "LUCY BARCLAY RECON REPORT", acViewPreview
End If

End Sub

I get the following error:

[June7]

What code is trying to set Column Count?

[pbaldy]

I moved all the code from the load event to the open event. I didn't use a button, I just opened the report from the nav pane, but it looked about like your picture.

[tonygg]

I moved the code to open and it works fine now. Sorry to have troubled you. Thank you so much. Tony

[pbaldy]

Happy to help Tony. You're not my brother Tony, are you?

[tonygg]

I guess not