Results 1 to 2 of 2
  1. #1
    Crazybrit is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2012

    Data vanishing in Subform after cascading comboboxes afterupdate

    Hi i have created a form with a subform for matches in a pool statistics database, on the main form i have hometeam name and awayteam name which cascade to the subform where i can enter details of the games played in the match i have done an afterupdate but as i scroll through the records the data in the subform disappears until i reselect the team name again in the main form i have attached a copy of DB
    Thanks for your time in advance
    Regards Crazybrit
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    This is a known issue of using cascading comboboxes with lookups in Continuous or Datasheet forms. There is no simple solution.

    Bear in mind that the combobox is one control. Even though it displays repeatedly on the form, it is the same control. So when you modify the RowSource property, that is what will show in all instances of the control until it is requeried. If the second combobox is multi-column and set to display the lookup alias, the combobox value will appear blank on some rows because the alias value is not available for those records.
    Last edited by June7; 12-04-2012 at 12:00 AM.
    How to attach file: 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. Trouble with Cascading ComboBoxes
    By shane201980 in forum Programming
    Replies: 3
    Last Post: 10-03-2012, 09:05 AM
  2. Replies: 9
    Last Post: 08-07-2012, 11:50 AM
  3. Cascading ComboBoxes
    By GAccess in forum Forms
    Replies: 1
    Last Post: 03-06-2012, 05:02 AM
  4. Symmetric Cascading Comboboxes
    By schwabe in forum Forms
    Replies: 15
    Last Post: 02-02-2012, 11:38 AM
  5. Cascading Comboboxes and Sub Forms
    By PaulCW in forum Forms
    Replies: 6
    Last Post: 10-07-2011, 12:08 PM

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