Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2009
    Posts
    32

    Unanswered: Command to Change Row Source

    Im trying to figure out what command I should use in VB to change a combo box's Row Source base on another combo box's selection?

    Would it be a DoCmd.?



    Any help would be greatly Appreciated...

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    It would probably be something like this:

    me.MyComboboxName.Rowsource = "Select...."
    or
    Forms!MyFormName!MyComboboxName.Rowsource = "Select...."

    or (I will sometimes just set the rowsource to a query name)
    me.MyComboboxName.Rowsource = "MyQueryName"
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Nov 2009
    Posts
    32
    Most excellent thank you!

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
  •