linking, filtering, combobox, recordset

[Chuckie]

I am having difficulties linking two comboboxes.

1) I've set up combobox1 to received values from field1 in
table1. However there are repeated values and I would
like to filter out the repeated values.

2) Then from the numbers that appear, i'd like combobox1
to link to combobox2. Combobox2 receives values from
field2 in table1. However, I don't want all the values
from field2 in table1 to apear (since it is about 80
numbers). I want combobox2 to only display the data that
is associated with the data chosen from combobox1.

3) When the value on combobox2 is pressed, I would like
for form1 to appear and take me to the exact record that
is associated with the value that was clicked on
combobox2. I've already created a form with the wizard
that has all the fields from table1 on it. And I've made
sure that the combobox2 values are unique. So I know
there is a way to do this since I've done it in VBE in
excel; but it happens to be different for access.


Please help. I really need to know this asap. So I need
to know how to
1) filter repeated values
2) link the comboboxes
3) link combobox2 values selected to the form's specific
record