Results 1 to 3 of 3
  1. #1
    JQuinnC is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2016
    Posts
    11

    combobox select problems

    I'm sure this has been asked and answered a thousand times, but I can't seem to find that thread. My Googlefu has failed me. I had a combobox to show my client names but I can't select them. I can start typing and it will autocomplete the name and allow me to go to the record, but I can't actually select from the list.The combobox source is a query. This image has the data settings. http://imgur.com/rPerNUT
    Attached Thumbnails Attached Thumbnails listbox.png  

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    since you are bound to col 1, and col 1 is the key,(not the name)
    in the format tabe, try setting col widths, 0;2
    (and data tab,# columns = 2)
    (so the ID is invisible, and the 2nd col, name, is shown)
    NOW , auto fill should work.

  3. #3
    JQuinnC is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2016
    Posts
    11
    Ok, figured it out.

    I had events in onclick. When I deleted them it worked.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Not able to select from combobox
    By Triel in forum Forms
    Replies: 19
    Last Post: 09-26-2014, 03:51 PM
  2. Select... in combobox
    By gemadan96 in forum Forms
    Replies: 1
    Last Post: 06-03-2014, 03:51 PM
  3. Impossible to select any value from the ComboBox
    By GaioAugusto in forum Programming
    Replies: 4
    Last Post: 12-31-2013, 03:29 AM
  4. Multi Select List Box Problems
    By Oblivinator in forum Forms
    Replies: 4
    Last Post: 10-24-2012, 04:53 AM
  5. Combobox and Saving problems
    By manicamaniac in forum Access
    Replies: 1
    Last Post: 07-31-2010, 11:58 PM

Tags for this Thread

Posting Permissions

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