Link combo boxes (1 Viewer)

[cos]

well the issue i have, is that when i select one value from one combo box, i want only a certain set of results appear in the second combo box related to the answer in the first, which i can select. :banghead:

Any ideas how i might be able to resovle this problem?
[and both of the values are to be recorded in the same table or something?]

 

[John Big Booty]

What you are looking for is a set of Cascading Combo Boxes.

 

[MStef]

Look at "Demo4ComboA2000.mdb" (attachment, zip).
Open Form and try. Adapt it in your MDB.