• Change row source for a combo box (2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Change row source for a combo box (2000)

    Author
    Topic
    WSaaucoin
    AskWoody Lounger
    May 9, 2003 at 2:30 pm #387252

    I have a combo box that needs to change its row source depending on the value of another combo box. Example: if cbo1 = “value1″ then cbo2 will draw its row source from table1. If cbo1 =”value2” then cbo2 will draw its row source from table2. Can anyone help with this?

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSAlexya1
      AskWoody Lounger
      May 9, 2003 at 3:18 pm #675197

      You need to add the following code to the BeforeUpdate Event for the cbo1… If there are more than 2 values that decide which table is the rowsource then you can use a Select Case structure…

      Forms!form1.cbo2 = “” ‘this will clear cbo2
      If cbo1 = “value1” Then
      Forms!form1!cbo2.RowSource = “YourTable”
      Else
      Forms!form1!cbo2.RowSource = “YourOtherTable”
      End If

      Oh… and you’ll still have to play with the Bound Column to figure out what field to display in cbo2…
      Hope this makes sense… Let me know if you need more detailed instructions… HTH

      Reply | Quote
    • WSaaucoin
      AskWoody Lounger
      May 9, 2003 at 5:31 pm #675256

      What is the proper way to reference a table as a row source?

      Reply | Quote
      • WSAlexya1
        AskWoody Lounger
        May 9, 2003 at 7:38 pm #675298

        Hmmm… sorry aaucoin… I’m not sure I understand what you are asking…

        If you want to know the proper syntax to designate a table as the row source its:
        Forms!frmName!cboName.RowSource = “tblName”
        (which means: Assign the table named “tblName” -> to the RowSource property -> of the combo box named “cboName” -> on the form named “form1” -> in the Forms collection… )

        If you want to know how to properly designate that the data to be contained in that combo box will be coming from a Table or Query, rather than a Field List or Value List… then this is the code:
        Forms!frmName!cboName.RowSourceType = “Table/Query”

        Let me know if I’m completely misunderstanding… HTH smile

        Reply | Quote
        • WSaaucoin
          AskWoody Lounger
          May 9, 2003 at 10:45 pm #675330

          You didn’t misunderstand me. I did want to know the proper syntax to designate a table as the row source. I was thinking that there was more to it than just the table name. I thought that I had to list the row in the table as well. The way I finally got it to work was:
          cboName.RowSource = “SELECT tblmodel.Model FROM tblmodel”
          I coppied the select statement from the row source in the properties and put it into the code. It took me a while to figure out that I needed to put quotes around the statement, though.
          Thanks for your help

          Reply | Quote
    Viewing 1 reply thread
    Reply To: Change row source for a combo box (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.