I have a form with two multi-select list boxes.
1. list box contains months (recordset = tmpInvoiceMth)
2. list box contains years (recordset = tmpInvoiceYr)
Once the user has chosen their corresponding months and years I would like to loop through both recordsets and add the corresponding Mth-Yr combination into a third recordset (tmpInvoiceMthYr)
EX: User chooses Jan and Feb from list box 1 and 2012 and 2013 from list box 2
after looping tmpInvoiceMthYr should contain the following records
Thanks as always for your assistance