listbox question again

  • Thread starter Thread starter adriany
  • Start date Start date
A

adriany

can i use listbox to hold temp data to print then
save what's in the listbox to table later
 
can i use listbox to hold temp data to print then
save what's in the listbox to table later

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.
 
Back
Top