Results 1 to 3 of 3
  1. #1
    dwheatley is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2017
    Posts
    22

    Combo box won't update field

    I have a combo box in which I typed in the values that I want (months Jan-Dec) on a form.

    1) When in Form View, I can click the drop down arrow on this box and see the months, but clicking them does nothing/they appear to not be clickable. I have checked and edits are allowed, and the box is not locked.



    2) I want the entry here to update a field in a table, tblDeadlines.Issue but it is currently unbound.

    Any help?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    sometimes the combo is set to the wrong Bound column.
    or 1 of the columns = 0

  3. #3
    Join Date
    Apr 2017
    Posts
    1,673
    The combo's Control Source must be bound to field in forms source table, where a value indicating the month is stored;
    The combos RowSourceType in your case will be "Value List";
    The combos RowSource will be either "Jan";"Feb";...,"Dec" (single field combo) or 1;"Jan";2;"Feb";...,12,"Dec", or more columns when you need them (you have to check list delimiter, it may be different for you);
    The combos ColumnCount depends on your choice of RowSource (1 or 2 for my examples);
    The combo's BoundColumn will be 1 for both of my examples. It determines the column in RowSource, value from which is stored to table. For my example p.e. when the column in table is MonthValue, then for 1st example this field must be text, for 2nd example smallint, and either p.e. "Jan" or 1 is stored to table - but "Jan" is displayed in combo for both cases;
    The combo's ColumnWidth will be p.e. 2 for 1st example, 0;2 (the second number can be anything > 0 - the first column with non-zero width is displayed) for 2nd example.

    With single-column combo, you can set LimitToList property to False - in this case you can enter values, not listed in combo's RowSource. Usually this setting is used, when the combo's RowSource is a SELECT DISTINCT query from field serving as combo's ControlSource - you can select values entered earlier, and you can add new entries at will - and those new entries will be added to selection list later.

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

Similar Threads

  1. Replies: 2
    Last Post: 08-16-2016, 03:26 PM
  2. Replies: 12
    Last Post: 02-15-2016, 11:10 AM
  3. Replies: 6
    Last Post: 02-01-2013, 10:02 AM
  4. Combo box update field in a different table
    By deadringer86 in forum Forms
    Replies: 3
    Last Post: 12-28-2012, 05:10 PM
  5. Calculate field after combo update
    By TinaCa in forum Forms
    Replies: 3
    Last Post: 06-06-2012, 12:16 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