Drop down lists [bigsmile]

[soojosie]

Can anyone help me with a 2nd drop down list that looks up data from the first drop down list? e.g. lst list is Flower 2nd drop down box has list of flowers?
Thanks

 

[PWise]

If your structure is that in your first list, you have a list of categories flowers, cars, foods, ect. and the second list you want to list all of that list

In the update event of the first list you have to add list2.rowsource= "select... where category='" & list2 & "';"
Single quotes only necessary when category is text

 

[gusbrunston]

[tt]
Hi, Soo Josie BigSmile:

It would help too, if you would assign these properties to your 2nd "drop-down list" (combo box):

RowSourceType: Table/Query
RowSource: (empty)

For a complete description see Microsoft Knowledge Base Article - 209595 on

http://www.microsoft.com.

Gus Brunston, using Access2000 Intermediate skills.