Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    2

    Unhappy Unanswered: Cascading Combo List Help

    Hey Guys,

    Anyone would be able to offer a newbie some help. I would most appreciate it. I am trying to work on a project where my company has Markets/Districts/Branches. I have created three seperate tables and also built the desired relationship. I am having trouble with the code... I can navigate from Markets to Districts, but my final step on Branch's combo box does not display the final branch results... Any ideas?

    Option Compare Database


    Private Sub CboMarketNo_AfterUpdate()
    Me.CboMarketNo.Requery
    End Sub

    Private Sub CboMarketNo_Change()
    Me.CboDistrictNo.Requery
    Me.CboDistrictNo = vbNullString
    End Sub

    Private Sub CboDistrictNo_AfterUpdate()
    Me.CboBranchNo.Requery
    End Sub

  2. #2
    Join Date
    Dec 2009
    Location
    Lake County, IL
    Posts
    8

  3. #3
    Join Date
    Jan 2012
    Posts
    2

    Smile Thank you!

    alansidman,

    Thanks for the prompt reply! I have been working on this database for a few days now and pretty much making it work. The only thing I am confused on is the fact that the Tables are being displayed on each drop down menu correctly, but somehow it retains the first value on the list on the two subsequent combo boxes. I don't seem to get it to work, so that the value I choose is fixed throughout the form. Please help....

    Krico

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •