Covert listbox on Form to display on Report

[Guest]

I have a listbox (value list, variable for each record) on a form together with other info. A command button on the form activates the printing of a report. I want to place the items of the listbox on the report without creating an intermediate table (which cause conflicts in a multiuser environment). Other info is placed on the report using an SQL query as source. I can put the listbox contents in a VBA array. How can I convert that array to an SQL query (without intermediate table) or is there another way?

 

[Gary Miller]

I don't think that you have provided enough details for much
help on how to convert your array to SQL, but if you have
your database properly split into a FrontEnd BackEnd
scenario with the FrontEnds on the individual users
machines, you will have no multiuser issues with creating
temporary tables as long as they reside in the individual
front ends.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message

I have a listbox (value list, variable for each record) on

a form together with other info. A command button on the
form activates the printing of a report. I want to place the
items of the listbox on the report without creating an
intermediate table (which cause conflicts in a multiuser
environment). Other info is placed on the report using an
SQL query as source. I can put the listbox contents in a VBA
array. How can I convert that array to an SQL query (without
intermediate table) or is there another way?