Results 1 to 6 of 6
  1. #1
    jj1 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    128

    Cascading combo boxes not showing previous saved records


    I made a form for users to go back and see saved records as and when required. However my cascading combo box are not showing the saved information. Information is saved in back end.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Not enough info. Please tell us WHAT you are doing, and any related code you think may be important.
    Did you requery your combos after having made an update?

  3. #3
    jj1 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    128
    Quote Originally Posted by orange View Post
    Not enough info. Please tell us WHAT you are doing, and any related code you think may be important.
    Did you requery your combos after having made an update?
    Private Sub cboRootCause_AfterUpdate()
    Me.cboMicroRootCause.Requery
    Me.cboMicroRootCause = ""
    End Sub
    I used this code to requery

    I have database in which I made a form in which I filter B based on A and C based on B.

    and I designed the form so that people can go back to the records in form and see previously saved records. However my combo box information is not showing previously saved records in the combo box and comes as blank. However combo box info is saved in backend

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    You are resetting the Me.cboMicroRootCause = "" to an empty string (would seem empty/no value)

    Try commenting that line and see what happens.

  5. #5
    jj1 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    128
    Doesn't make any change

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    As orange said, if the combobox is bound to field and you set the combobox to "" then you are replacing record data with empty string. I don't see how data was ever saved.

    Are these comboboxes on Continuous or Datasheet form? Are these comboboxes multi-column with alias? That won't work on Continuous or Datasheet.

    If you want to provide db for analysis, follow instructions at bottom of my post.
    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. Replies: 11
    Last Post: 08-06-2014, 09:47 AM
  2. Replies: 15
    Last Post: 04-16-2014, 01:15 PM
  3. Replies: 12
    Last Post: 02-01-2013, 02:25 PM
  4. Replies: 3
    Last Post: 10-17-2012, 03:16 PM
  5. Replies: 7
    Last Post: 10-28-2011, 03:42 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