combo boxes

[ravindarjobs]

i have placed two combo boxes say combo1 and combo2 on a form in detail section.

i have two tables
1. Name
2. Accounts

combo1 holds the "Name" table values. i.e its row source property set to the values of "Name" table.

I want combo2 in such a way that it displays values related to Combo1.

in detail,


Note that i have placed them in detail section. so the form displays the entire data from the tables "Name" as a series of rows.
i have placed combo2 next to combo1 in detail section.
when form is opened it displays a series of rows of data shown by combo1 but combo2 shows empty values. (combo2 displays empty values because its row source is not defined)

"Accounts" table holds columns "AccName" "AccNo"
"AccName" contains the same names as in the "Name" table and also will contain many duplicate names.

Now if i select one value in combo1 in particular row, the combo2 in that row must show values only relating to combo1.

suppose if i select a value "ABC" in combo1 then combo2 must hold the list Values from table "Accounts" where AccName = value selected in combo1 for that row.

How can i make this?

it seems that my way of explaination has confused you.
i am sorry.
but please do answer.

Thanq

[FishVal]

Hi, there.

Take a look at this tutorial Cascading Combo/List Boxes