Print values of a listbox

[Mercadogs]

Is there a way to make a report that prints the values of a form's listbox.

I tried making a report in design view to accomplish this. I inserted a
listbox in the report and made it bound to the form's listbox, but the report
only prints a limited amount of items on the list (those which are visible in
the listbox).

Is there a way to have the report print all the values of the form's listbox?

 

[Jerry Whittle]

How is the list box populated? If it's based on a table or query, make a
report based on that table or query.

If the Row Source Type is a Value List, I don't know....

 

[Mercadogs]

Hi Jerry:

Thanks for your response.

The list is populated from a query called "Sp" that is filtered by entering...

SELECT DISTINCT Sp.PartNum, Sp.Loc FROM Sp ORDER BY [PartNum];

..... in the rowsource property of the listbox.

I had to manipulate this property because otherwise I could not make a new
query that would allow me to set property of the new query to 'unique values'
in order to get distinct combinations of 'PartNum' and 'Loc' fields of the
query 'Sp'. For some reason queries that have the "Group By" commands give
this problem.