I have database like this

Manufacture Model No Length Width height

Manufacture 1 MD-01 200 300 100

Manufacture 1 MD-02 300 400 100

Manufacture 1 MD-03 400 300 150

Manufacture 2 MAD-01 200 450 100

Manufacture 2 MAD-02 250 400 100

Manufacture 3 MDI-01 300 300 100

Manufacture 4 MOv-01 350 300 100


I would like to create 2 combobox -

1) Manufacture 2 ) model No

Manufacture should display for above example Manufacture 1,Manufacture 2,Manufacture 3, Manufacture 4

when particular manufacture selected for example Manufacture 2 -> combox should display only MAD-01 & MAD 02.

Based on both selection text box must me loaded with length, width , height.

i tried sample code & try to assign the combox with database value. I found duplicate list of column. Like for combobox1 accumulate

Manufacture 1

Manufacture 1

Manufacture 1

Manufacture 2

Manufacture 2

Manufacture 3

Manufacture 4

Is there any example program available to do this. How can do this.

Sounds like what you wan to do is often called cascading combo boxes.

Note: This does not work well for a form in datasheet or continuous view modes.

I would expect that you have a manufacture table. That is what would be used for the first combo box. The list of items in the second combo box would filter the records based on the Manufacturer ID from the first combo box.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015