Error Using List Box with Simple Multi Select

[moke123]

see if this helps. There are also a bunch of different options in the listbox examples db.

[MichaelA]

That did it! Thank you, so much. I would never have been able to figure that out.

see if this helps. There are also a bunch of different options in the listbox examples db.

[MichaelA]

OK, slight problem. When I double click in lstEnrolled to remove a course, I get the confirmation to remove, when I click yes I receive "Run-time error '3061': Too few parameters. Expected 1.

I have made a few changes but only to field names.

see if this helps. There are also a bunch of different options in the listbox examples db.

[moke123]

Cant help you without seeing your changes and the double click event code.

[MichaelA]

I've attached the db as is

Cant help you without seeing your changes and the double click event code.

[moke123]

you had

strSql = "Delete * from tblCourseEnrollment where StudentCourseID_FK = " & Me.lstEnrolled

when it should be

strSql = "Delete * from tblCourseEnrollment where StudentCourseID_PK = " & Me.lstEnrolled

[MichaelA]

Thank you! Everything is working great now.

you had

strSql = "Delete * from tblCourseEnrollment where StudentCourseID_FK = " & Me.lstEnrolled

when it should be

strSql = "Delete * from tblCourseEnrollment where StudentCourseID_PK = " & Me.lstEnrolled

[moke123]

Good luck with your project