I've looked through several related solutions here and remained confused. What I'd like is a simple answer to a simple version of the multi-list box question.
Here are my components:
form: frmSendOrder
controls: lbxApproved (multi-select list box) and cmdPrint (command button where code should before the report prints)
table: tmpPrintOrder (emptied before fill begins)
field: DistOrderID (only field)
I'm using Access 2002 and simply want to populate the table with a record for each selected item in the list box control.
Start Free Trial