View selection from multi list box as report
Posted on 2011-02-24
I have a form with a multi select list box. The user selects multiple rows in the list and clicks a button to add those records to a table.
Using the following code:
If Me.ListClass.Selected(x) = True Then
DoCmd.RunSQL ("Insert Into ShowTime1 ([Meeting Date],[Rider], Horse, BackNo, Agroup, Class) VALUES (cboDate,cboRider,cboHorse,txtBack,cboAgeGroup,'" & Me.ListClass.ItemData(x) & "')")
However, I need to print a list of what has been selected and add info from a couple of other fields on the form to provide to the user.
Date (from text box)
Name (from text box)
Selected Items (rows selected in list):
Any help is greatly appreciated!