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

    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

    Re: List Box Dependent Upon Combo Box

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


    you'll see the others as well..

    The 'column' property is what you're after

  3. #3
    Join Date
    Sep 2003
    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