Page 2 of 2 FirstFirst 12
Results 16 to 23 of 23

Error Using List Box with Simple Multi Select

  1. #16
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    360

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

  2. #17
    MichaelA is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2019
    Location
    Wisconsin
    Posts
    71
    That did it! Thank you, so much. I would never have been able to figure that out.

    Quote Originally Posted by moke123 View Post
    see if this helps. There are also a bunch of different options in the listbox examples db.

  3. #18
    MichaelA is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2019
    Location
    Wisconsin
    Posts
    71
    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.


    Quote Originally Posted by moke123 View Post
    see if this helps. There are also a bunch of different options in the listbox examples db.

  4. #19
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    360
    Cant help you without seeing your changes and the double click event code.

  5. #20
    MichaelA is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2019
    Location
    Wisconsin
    Posts
    71

    New Attachment

    I've attached the db as is

    Quote Originally Posted by moke123 View Post
    Cant help you without seeing your changes and the double click event code.
    Attached Files Attached Files

  6. #21
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    360
    you had
    Code:
    strSql = "Delete * from tblCourseEnrollment where StudentCourseID_FK = " & Me.lstEnrolled
    when it should be
    Code:
    strSql = "Delete * from tblCourseEnrollment where StudentCourseID_PK = " & Me.lstEnrolled

  7. #22
    MichaelA is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2019
    Location
    Wisconsin
    Posts
    71
    Thank you! Everything is working great now.

    Quote Originally Posted by moke123 View Post
    you had
    Code:
    strSql = "Delete * from tblCourseEnrollment where StudentCourseID_FK = " & Me.lstEnrolled
    when it should be
    Code:
    strSql = "Delete * from tblCourseEnrollment where StudentCourseID_PK = " & Me.lstEnrolled

  8. #23
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    360
    Good luck with your project

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-21-2014, 01:16 PM
  2. Replies: 15
    Last Post: 11-20-2013, 04:30 PM
  3. Multi Select Simple Returning No Results
    By jsimard in forum Programming
    Replies: 11
    Last Post: 01-24-2012, 10:28 PM
  4. Replies: 1
    Last Post: 10-22-2010, 10:11 AM
  5. Replies: 1
    Last Post: 02-25-2009, 07:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums