Multi filtering with comboboxes

[petertje]

Ey petertje here,

I have three comboboxes and I want to have the first one filter the second one and the filtered second one filter the third one.

Filtering the first one on the second one works, but when I whant to add a third one to it, it just shows blank spaces on the third one.

What I did to the first and the second combobox :

1: I pressed the second combobox.


2: Went to rowsource.
3: filled criteria in on the value i whant to connect the first combox to the second combobox ( [Forms]![Thetableimin].[1stcombobox].
4. requery the second combobox in programcode on the first combobox.

What I did to the second and the third combobox:

1: I pressed the third combobox.
2: Went to rowsource.
3: filled criteria in on the value i whant to connect the second combobox to the third combobox ( [Forms]![Thetableimin].[2ndcombobox]
4. requery the third combobox in programcode on the second combobox.

So my question is : How do I make a third combobox that uses the filtered values of the second combobox to filter the third combobox.

Thanks in advance!

Petertje

[ItsMe]

A search for Cascading Comboboxes or Dependent Combo Box will provide examples.

I posted a sample here with three comboboxes.
https://www.accessforums.net/sample-...tml#post191005

[petertje]

I just looked at your code you provided in your thread, but does this also works when the first combobox is not related to the third combobox?
What I have as values is :

combobox 1 has the values:
Carnumber
Seatnumber

Comboxbox 2 has the values:
Carnumber ( carnumber in combobox 2 is related to carnumber in combobox1)
Name of car

combobox 3 has the values
Name of car ( name of car in combobox 3 is related to name of car in combobox2)
Number of cars.


so combobox1 filters combobox2 with carnumber and the filtered combobox2 filters combobox2 with name of car.

[ItsMe]

Sorry that I did not notice your reply to this thread.

Can you post the code you have tried so far?

[June7]

Not really understanding data structure.

Can there be more than one car number for the same car name? Why is 'Number of cars' not included as a column in second combobox?

If you want to provide db for analysis, follow instructions at bottom of my post.