Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    14

    Unanswered: Basic Combo Question

    Hello,

    Basic question...I have a combobox that I want to populate with values based on another combobox selection.

    As an example...
    If Info = "Scope" Then
    .RowSource = ""
    .RowSource = "SELECT tblScopeList * FROM tblScopeList;"
    End If

    I can grab the correct value from the 1st combobox...I just can't get the .RowSource to grab the data in tblScopeList.

    Any idea?
    Chaci

  2. #2
    Join Date
    Apr 2003
    Posts
    280
    Quote Originally Posted by orraytaft
    Hello,

    Basic question...I have a combobox that I want to populate with values based on another combobox selection.

    As an example...
    If Info = "Scope" Then
    .RowSource = ""
    .RowSource = "SELECT tblScopeList * FROM tblScopeList;"
    End If

    I can grab the correct value from the 1st combobox...I just can't get the .RowSource to grab the data in tblScopeList.

    Any idea?
    try this...

    .RowSourceType = "Table/Query"
    .RowSource = "SELECT tblScopeList(put period between these two)* FROM tblScopeList Where (needs a criteria here from combo box 1);"


    If it still doesn't work, look at your column width size in the property.

Posting Permissions

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