Consulting

Results 1 to 3 of 3

Thread: Solved: Comobobox not working properly

  1. #1
    VBAX Newbie
    Joined
    Apr 2005
    Posts
    4
    Location

    Solved: Comobobox not working properly

    A combobox on my form is not working properly. It works fine when you select an item from the dropdown list. But then you enter a value (by keyboard) that is in the dropdown I get each time the NotInList event. Then the NotInList event will generate an error because the item is allready in the list.

    Any idea's about what's going wrong?

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    The most likely reason for this error is that you are entering what you want to see rather than the Bound Column. This happens if you have 2 columns where say one is the key field, and ID or similar (which Access hides for you) and the other is a name etc that you want to choose. If you type the name in you get an error because Access expects the ID.

  3. #3
    VBAX Newbie
    Joined
    Apr 2005
    Posts
    4
    Location
    I found the error. It seemed releated to a missing library of an ActiveX usercontrol. Removing the reference to the missing library solved the problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •