Report based from a ListBox

[KimmyGoose]

I would like to create a report from a listbox on a form. The listbox
on the form is not based from a query. There are search options on the
form that change the listbox.rowsource via code. I would like to make
a print out of the records that are present in the listbox. I cannot
create a query based off of the listbox since the source is changed
every time the user uses the program. How can I creatre a report based
from the listbox rowsource?

 

[Larry Linson]

I would like to create a report from a listbox on a form. The listbox
on the form is not based from a query. There are search options on the
form that change the listbox.rowsource via code. I would like to make
a print out of the records that are present in the listbox. I cannot
create a query based off of the listbox since the source is changed
every time the user uses the program. How can I creatre a report based
from the listbox rowsource?

If you know what fields you want to report, you can create a report, and
replace its RecordSource with the RowSource of the Listbox. That's the
simplest situation and simplest approach.

A listbox would contain Fields, so at least you would have to know the
maximum number, and how large the Text Boxes would need to be to display
them.

Creating a new Report in Design View, completely from code, would be more
work than my clients would be willing to pay for (and perhaps more than I'd
care to undertake).

Larry Linson
Microsoft Access MVP

 

[KimmyGoose]

Thank you. I created a report were its recordsource was set equal to
the rowsource of the listbox on the form. I placed this code in the
open event of the report. Thanks for the help.