Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    122

    Unanswered: List Box Dependent Upon Combo Box

    I have a list box based on a stored procedure with one variable parameter. That parameter is not the same as the bound column of the combo box (it is one of the values, just not the bound value).

    What I want to do is have the list box parameter based upon the selection made in the combo box. Again, the value selected in the combo box is not the bound column.

    Please help.

  2. #2
    Join Date
    Mar 2003
    Location
    Bogota
    Posts
    67

    Re: List Box Dependent Upon Combo Box

    look up the following properties of list and combo boxes in the vba help files:

    column
    listindex
    itemdata

    you'll see the others as well..

    The 'column' property is what you're after

  3. #3
    Join Date
    Sep 2003
    Posts
    122
    The column property looks like the one I need, but I guess I'm not sure where or when to use it. What I would like to see happen is as soon as I select something from the Combo box, I would like the list box updated based upon that selection. Remember, the list box is based on a stored procedure, so I assume I have to pass that column info to the stored procedure. Where and when? Thanks.

Posting Permissions

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