Not at all easily. A Listbox typically draws data FROM a table. You
could with some difficulty write VBA code to set up a listbox's Value
List, and more code to display the data on a Report - but it really is
NOT an appropriate tool for this purpose!
Could you perhaps use a Subform (rather than a Listbox) to save the
data to a temporary table? Base the Report on this table, and then run
an append query to copy the temp table to your permanent table.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
