Combo Box

[davidnjt]

I have a combo box that displays items from a database when the form is loaded.

When the user selects one of the items from the list I then need to display items from another database in a list box.

Combo box is cboCategory

I tried if cboCategory="XXXXX" then
etc

Any help to get me in the right direction would be appreciated.

[mendhak]

You must populate the listbox in the Change event of the combobox.

You check the combobox value like this:

Combo1.List(Combo1.ListIndex)

Depending upon the value there, you can populate your listbox.

[manavo11]

The change event of a combo box works like the one of a textbox. When you type in the "text" part of the combo box, it's fired. If you want to detect when one of the options was selected, you'll need the click event

[mendhak]

Typo.


No, really... typo. <--- blushing.

[Wokawidget]

The change evenmt is ONLY fired if the combo is of a standard combo style, and only if you keypress in the combo.
If you drop the list down and select an entry then ONLY the click event gets fired.

If the combo is a drop down list then the change event NEVER gets fired, even if you keypress on it.

Just thought I'd point that out...but you lot knew that anyways

Woka

[davidnjt]

So from what I can get from the above posts when you select an
item from a dropdown combo box you need the on click event.

Does that mean I dont need to have any logic in my text box. ie do I put all the logic in my combo box so then when something is selected it displays items in the text box?

[mendhak]

Correct.