I'm having trouble with the multi select listbox (Lesson 321).  I does not want to run a new private sub after the loop for the itemsselected function... I always get an error message that highlights my private sub command and doesn't want to run it. I was able to go as far as getting the message box to display the data, but the steps after that pulled up an error message.

I'm trying to run it on a customer entry form where the listbox displays the tanks open for assignment to new customers.  I want to be able to select one or multiple tanks to assign to that customer and update my tanks table so that it shows the customer ID that the tank has been assigned to.  

I'm sure that there are easier ways to do this with update queries and the sort, but i really want to learn what I'm doing wrong with the vb/recordset code.

I tried downloading the student databases to see what I was doing wrong, but for some reason, my password doesn't work to open it.

---

Reply from Richard Rost:

Let's see your code. Post it here and note which line is throwing up the error.