Results 1 to 6 of 6
  1. #1
    j6sander is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2012
    Posts
    6

    disappearing combo box value

    So i have an Address dynamic combo box that is based off of my ClientName field. The ClientName field on the form hides the ClientNameID (primary key), displays the ClientName on the Form and stores the primary key in the associated table. That works great. However my dynamic combo [Address] that is based off of the ClientName field does not work. It too is suppose to be a two column combo box displaying Address, hiding AddressID and storing Address ID. But it seems broken. It DOES store the AddressID in the table. It DOES display only the Address and hide the primary key on the form. However, when you go back through the form to previous entries the Address field is blank. Displays neither the Address or hidden key. Even though it still displays the correct ClientName and the AddressID field is filled in properly on the associated table. Here's the funny thing, if the ClientName is the same as the most recent one I entered in new form then the Address will display correctly in previous records. What is going on?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Need to requery the combobox RowSource when moving to existing record. Use the form Current event, then:
    Me.comboboxname.Requery.

    The form is in Single view?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    j6sander is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2012
    Posts
    6
    split view

  4. #4
    j6sander is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2012
    Posts
    6
    Thanks for the help, that solution will work. Still tho, I wonder why in the split form view it will only show the entries in Address that match the current entry in the form, and the rest in the column display blank.

  5. #5
    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
    For the Combobox to be Record-appropriate , as you scroll from Record-to-Record, it must be Bound to the Address Field in the underlying Table. Apparently the cbo is Unbound.

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

    All posts/responses based on Access 2003/2007

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    That's the way bound dependent comboboxes behave in Continuous or Datasheet view (or the datasheet part of Split form). It is a known issue with combobox using lookup. When the RowSource property is changed it is changed for all instances of the combobox, because there really is only one combobox, as you can see in Design view. So the related values are not available for display in all of the records as they have been filtered out of the RowSource set.
    Last edited by June7; 09-11-2012 at 12:51 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Create menu keeps disappearing
    By thart21 in forum Access
    Replies: 1
    Last Post: 12-18-2011, 01:59 AM
  2. Disappearing checks in check boxes
    By jimmonator in forum Forms
    Replies: 3
    Last Post: 07-21-2011, 02:57 PM
  3. The amazing disappearing VBA code
    By Michele Keck in forum Forms
    Replies: 2
    Last Post: 10-01-2010, 11:44 AM
  4. Stoping Times disappearing
    By AJH1984 in forum Access
    Replies: 10
    Last Post: 06-19-2009, 05:46 AM
  5. Replies: 0
    Last Post: 06-11-2009, 09:51 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