G
Guest
This question has two parts
1)I am trying to create a form that will have a few combobox's in it.
the records source for each of them will be a diffrent field in the same
table.
I want it that when i pick the first combobox, it will after refliter the
othercombobox/form that way it will display in the next combobox only the
ones that have the same as in the first one. for example:
colum a colum b colum c
A R F
A C G
B R
H
B E
I
So when i select A from colum a, all that will be displayed in colum b is
"R" and then when i select "R" all that will display in colum c is "F", since
that is the only thing that has "A" & "R".
2)I then want it then when i select F if will place that record into a
diffrent textbox in a diffrent form.
any help will be most appreciated.
thank you
1)I am trying to create a form that will have a few combobox's in it.
the records source for each of them will be a diffrent field in the same
table.
I want it that when i pick the first combobox, it will after refliter the
othercombobox/form that way it will display in the next combobox only the
ones that have the same as in the first one. for example:
colum a colum b colum c
A R F
A C G
B R
H
B E
I
So when i select A from colum a, all that will be displayed in colum b is
"R" and then when i select "R" all that will display in colum c is "F", since
that is the only thing that has "A" & "R".
2)I then want it then when i select F if will place that record into a
diffrent textbox in a diffrent form.
any help will be most appreciated.
thank you