Linking ComboBoxes

[Aaron Howe]

Firstly, apologies for posting such a rudimentary question for which there
appear to be so many web resources available. Unfortunately I don't seem to
be able to grasp this most basic concept!

I would like to link the available options of one ComboBox directly to the
selection of another. I have two tables : Range and Product. A selection in
Range will be one of three options, which are linked to the CB and work
perfectly. The second CB should - and does - display available products
(ProductName); however it displays ALL products rather than the ones which
relate specifically to the selected range.

I gather there is an AfterUpdate function to make this work - but it doesn't
for me. My tables and fields are as follows:
Table: Ranges - contains an ID and a Range
Table: Products - contains field Range: which is linked from Ranges, and
field ProductName: which is user-entered into the table

So, a user selects a range and is then presented with an abbreviated
ProductName list based on that range. Ideally, ProductName would also only
display unique items rather than *EVERY* item as it currently does (a
ProductName can exist many times in different colors). Color would be the
next selection based on the same logic.

Will some klind soul help a man who hasn't used Access since 2003 and is
struggling to remember anything??!

 

[KARL DEWEY]

Search on Cascading Combo to find what you need.

 

[Aaron Howe]

Thanks, but as I said before the examples I have found don't seem to be
helping - many times because they're relevant to earlier version of Access,
or refer to controls through colloquial names rather than their actual
identifiers.

I'm sure it is indeed a cascading combo I need, but reading other peoples
examples which don't quite match what I'm looking for just confuses the
matter for me.

Is anyone able to advise beyond searching as I already have done?