Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Ceichhorn is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2017
    Posts
    23

    Combo Box will not allow selection to be made

    Hi all! Odd problem here, I assume I'm missing something obvious.

    I have a combo box that seems like it should be straightforward: just a gender choice combo box. The row source is pulled from a tblGender table, and I want the selection to control a field in a different table (in this case tblconsumers). The rows populate correctly, but the combo box will not let me actually make a selection. I've checked to make sure that the control source is labeled correctly, and it is; I have rebuilt the combo box as well to see if there was just some setting wrong, and the new combo boxes present with the same symptom -- rows populate correctly (Male/Female/Unspecified), but I am unable to actually make a selection to populate the control source.



    Any ideas what could cause this? Thanks in advance!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It sounds like the Control Source is *not* update-able.

  3. #3
    Ceichhorn is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2017
    Posts
    23
    Quote Originally Posted by RuralGuy View Post
    It sounds like the Control Source is *not* update-able.
    Thanks for the reply RuralGuy -- can you tell me how to make it update-able? The combo box is listed as Enabled and not Locked.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The ComboBox (cbo) is bound to a field in the RecordSource of the form. It is probably this field that is not update-able. If it is a query then open that query directly and see if you can change that field.

  5. #5
    Ceichhorn is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2017
    Posts
    23
    Quote Originally Posted by RuralGuy View Post
    The ComboBox (cbo) is bound to a field in the RecordSource of the form. It is probably this field that is not update-able. If it is a query then open that query directly and see if you can change that field.
    RuralGuy,

    I went to the table (it is a table in this case) that is the control source for the form and updated the fields manually. It did allow me to update those fields - in the sense that I could put a number in the field for any given record and save it without issue -- but the data saved in those fields did not populate when I went back to the form.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Hmm...What is the Field Type? Is it a text field? What is the field type of the tblGender table? Did you use the wizard to create the cbo? More questions in a bit.

  7. #7
    Ceichhorn is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2017
    Posts
    23
    Quote Originally Posted by RuralGuy View Post
    Hmm...What is the Field Type? Is it a text field? What is the field type of the tblGender table? Did you use the wizard to create the cbo? More questions in a bit.
    Rural,

    The control source of the combo box (again, in this case, lngGenderID in tblConsumers) is a long integer type, as is the lngGenderID field in tblGender. Those seem to match up. I tried to build the combo box from scratch and also using the wizard. I also copy/pasted a combo box which is working, swapped out the row/control sources to Gender, and again got the same result.

  8. #8
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    If, by "the combo box will not let me actually make a selection," you mean that when you click on a selection nothing happens, it's probably related to one of the Form's properties.

    The Access Gnomes, in their infinite wisdom, look at the act of using of a Combobox as a form of Editing a Record; hence if AllowEdits is set to No/False, they cannot be used!

    FYI, if you need to

    • Use a Combobox
    • Not allow editing of Records

    the workaround is to

    Set AllowEdits to Yes/True and Lock or Lock and Disable all of the Controls on the Form.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  9. #9
    Ceichhorn is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2017
    Posts
    23
    MissingLinq,

    This property is distinct from "Allow Value List Edits," or are they the same? If they are different, then where in the property sheet is "AllowEdits" listed? I know I can set "Allow Edits" at the form level, and that is set to true/yes, and other combo boxes on the form are working correctly -- just not these two! Both non-functioning combo boxes are listed as Enabled-Yes and Locked-No.

  10. #10
    Ceichhorn is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2017
    Posts
    23
    New update: the fields which are the control sources for these combo boxes are not indexed in the table from which they originate. Is that a problem?

  11. #11
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by Ceichhorn View Post
    New update: the fields which are the control sources for these combo boxes are not indexed in the table from which they originate. Is that a problem?
    That should not be a problem. What are the values of the cbo properties:
    Row Source:
    Row Source Type:
    Bound Column:
    Column Count:

  12. #12
    Ceichhorn is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2017
    Posts
    23
    Quote Originally Posted by RuralGuy View Post
    That should not be a problem. What are the values of the cbo properties:
    Row Source:
    Row Source Type:
    Bound Column:
    Column Count:
    Thanks again for the help RuralGuy.

    Row Source: SELECT tblGender.lngGenderID, tblGender.strGender FROM tblGender ORDER BY tblGender.strGender;
    Row Source Type: Table/Query
    Bound Column: 1
    Column Count: 2

  13. #13
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Try setting your Bound Column to 0 instead of 1.

  14. #14
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Based on your Row Source, the Bound Column should be 1 as you had it but I was just trying to see if we could change the symptom at all.

  15. #15
    Ceichhorn is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2017
    Posts
    23
    RuralGuy,

    I found the issue! I had looked to see if the combo boxes were handled via program in VBA, and they were not, as no combo boxes were referenced explicitly in the code and all of them had control sources bound explicitly; however, what I did not notice is that a portion of the code on load called qryConsumers, rather than tblConsumers, as its source, and this query did not have those fields added to it. Once I added lngGenderID to qryConsumers, the issue went away. I didn't look at the code closely enough (I didn't write it in the first place). Sorry for the confusion, and thanks for your help!

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

Similar Threads

  1. Replies: 2
    Last Post: 11-26-2016, 05:43 PM
  2. Replies: 5
    Last Post: 08-05-2014, 09:13 AM
  3. Replies: 10
    Last Post: 01-31-2014, 09:47 AM
  4. Replies: 3
    Last Post: 07-03-2013, 10:38 AM
  5. Replies: 3
    Last Post: 12-11-2012, 09:12 AM

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