Results 1 to 2 of 2
  1. #1
    libraccess's Avatar
    libraccess is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Napier New Zealand
    Posts
    129

    Cascading Combo from Main to Sub

    I have the first cbo on the Main form and the second cbo on the Subform



    I have this working OK except when I move away from a record when I return the control is blank.
    If I go to the Main Form cbo and reselect the Original the subform selections repopulate correctly soon as I after update.
    So I think ive fixed this, but is this the right way, good way or any other way? Deliv is the subforms Control Name

    Private Sub Form_Current()
    Me.Deliv.Requery
    End Sub

    it works but as I said is this good?

  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,929
    I have never seen main/subform dependent comboboxes. If the Requery is producing the desired result then good.
    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. Cascading Combo Box Help
    By euphoricdrop in forum Forms
    Replies: 3
    Last Post: 04-12-2011, 05:35 PM
  2. Replies: 5
    Last Post: 01-02-2011, 10:09 AM
  3. cascading combo
    By rexb in forum Forms
    Replies: 9
    Last Post: 10-26-2009, 04:10 PM
  4. Replies: 0
    Last Post: 08-17-2008, 12:19 PM
  5. Cascading Combo Box
    By nywi6100 in forum Forms
    Replies: 0
    Last Post: 10-23-2006, 01:45 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