C ！How can I use the content in one combo box to control the content in another combo box?

Let's talk about the idea: This obviously needs to use ado

1. Connect to the database and get the connection object conn

2. Open the table with the following select statement and read the data into RecordSetSet rs="select * from the table name"3. Use a loop to read the data into a two-dimensional array arr

row=0while not

arr[row,0]=rs["id"]

arr[row,1]=rs["year"]arr[row,2]=rs["mon"]

arr[row,3]=rs["1"]

arr[row,4]=rs["2"]

row=row+1

wend

This is best done in a database way, or it can be implemented directly. But that would be more troublesome.

Select the cell you want to fill, select "Data" - "Validity", and set the Validity condition to Allow: "Series", **:"Fax Machine, Printer" (Note the middle.)','To use the English input method,To separate),Finalize it.。

See if it's the effect you want.

Put two combination bai boxes in the window, and give you this du** you try to see if you can implement the dao

If so, please adopt the answer within the time.

Version Capacity 2 Assembly Window Assembly 1

The subroutine Combo Box 1 list item is selected.

The first count cycle (combo box 2.)Take the number of items () in the combo box 2Delete the item (0).

Counting cycle tail ().

- The above ** implements the ——— of clearing all items in combo box 2'– The following ** implements the project that rejoins the combo box 2 according to the different contents. Judgment begins (combo box 1.)Content Beijing") combo box 2

Join the project ("Forbidden City",

Combo Box 2Join the project ("Summer Palace",

Judgment (Combo Box 1.)Content Guangzhou").

Combo Box 2Join the project ("Up and Down Nine,".)

Combo Box 2Join the project ("Little Waist",

Default. End of judgment.

Your question is a multi-level drop-down menu problem, please refer to the gif tutorial in my i post bar.

I don't know if it's a problem with our level, or if you have a problem with your expression, as far as I know, the combo box.

You can only select one content, and if you're talking about setting multiple content selections, that's easy, select the combo box, select the set list items, and then insert them one by one.

Under the visual interface, you can only choose one by one, if you use the project index to get it, good.

Seems like another question.

If this is the effect you want there will be no can I if it is a combo box visualization.

Select multiple content under the interface.,Then I won't.。。

Combo box Can you select more than one content?

You're not mistaken, right?

Let's talk about the idea: This obviously needs to use ado

1. Connect to the database and get the connection object conn

2. Open the table with the following select statement and read the data into RecordSetSet rs="select * from the table name"3. Use a loop to read the data into a two-dimensional array arr

row=0while not

arr[row,0]=rs["id"]

arr[row,1]=rs["year"]arr[row,2]=rs["mon"]

arr[row,3]=rs["1"]

arr[row,4]=rs["2"]

row=row+1

wend

Introduce a software to you [Kaka Assistant, 360 Guard], there are traces of cleaning inside, it's very easy to use, think about everything, it's not big, it's less than 2m, and there are some other functions, it's very practical.

combobox controls, right? Just find "DropdownStyle" in the list of properties and set it to Dropdownlist.