Hi
At time index 3:50 were you add the line of code

Set rs = db.OpenRecordset("SELECT * FROM CustomerT WHERE CustomerID=" & CustomerList)

I get the following error:

run-time error 3075
syntax error (missing operator) in query expression 'CustomerID='

after double clicking from the list box.

Now the strange thing is, this worked fine the first time I went through this lesson. I came back just to recap what I had learned once I had finished the lessons upto lesson 4, and found afer some time of going over all the code, that when i turn the multi select back to normal the double click event worked again.

Could this be a bug in the code or program?