Base report on form listbox?

[bruce]

Hello,

I have a small form that pops up when a user moves off the current
record of a rather sizeable data entry form. The purpose of this form
is to list warnings about various fields on the entry form that may be
incomplete or inconsistent before the user exits the record. These
warnings take the form of items in a listbox. The underlying rowsource
of the listbox is a delimited string (value list). I would like to be
able to let the user print a nicely formatted report of the items in
the list. I could create a temporary table to use as the rowsource of
the listbox and the report but before I redo what I've already got, I'm
wondering if there is a way to print a report based on my listbox or
its value list using code using the report detail's format or print
events to grab column values from the listbox. Ideally I'd like to
create a report with three textboxes in its detail section, each
corresponding to a column in the listbox on my warning form. I've been
fooling around with looping through the listbox rows in the report's
detail format event and setting the value of each text box to the
proper column but I only end up with the last row of my listbox
printing on the report. I know I could also use the report's print
method, but like creating a temp table, that's more hassle than I want
to go through.

Has anyone done anything like this? Any suggestions? Thanks.

Bruce

[MGFoster]

br***@aristotle.net wrote:

Hello,

I have a small form that pops up when a user moves off the current
record of a rather sizeable data entry form. The purpose of this form
is to list warnings about various fields on the entry form that may be
incomplete or inconsistent before the user exits the record. These
warnings take the form of items in a listbox. The underlying rowsource
of the listbox is a delimited string (value list). I would like to be
able to let the user print a nicely formatted report of the items in
the list. I could create a temporary table to use as the rowsource of
the listbox and the report but before I redo what I've already got, I'm
wondering if there is a way to print a report based on my listbox or
its value list using code using the report detail's format or print
events to grab column values from the listbox. Ideally I'd like to
create a report with three textboxes in its detail section, each
corresponding to a column in the listbox on my warning form. I've been
fooling around with looping through the listbox rows in the report's
detail format event and setting the value of each text box to the
proper column but I only end up with the last row of my listbox
printing on the report. I know I could also use the report's print
method, but like creating a temp table, that's more hassle than I want
to go through.

Has anyone done anything like this? Any suggestions? Thanks.

The easiest solution is to print the form the ListBox is on.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)