Multi filtering with comboboxes.

[jan pieter]

Ey Jan Pieter 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!

Jan Pieter

 

[JHB]

Show your query for the third combo box, (and also the name for the second combo box).
Else post you database with some sample data.

 

[jan pieter]

Thanks for responding!

So these are the values im working with:


combobox1 has the values:
Carnumber
Seatnumber

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

combobox3 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.

- Jan pieter

 

[JHB]

Okay - but I meant the query string, behind the combo boxes.
Have you checked the Column count and the Column Widths for the combo box?

 

[jan pieter]

Oh I hope this is where you're searching for:

combobox1

controlelement: voorstellingnummer

Rowsource:

SELECT [Voorstellingen].[Voorstellingnummer], [Voorstellingen].[Titel], [Voorstellingen].[Uitvoerende]
FROM Voorstellingen
ORDER BY [Voorstellingnummer];

combobox2

controlelement: uitvoeringnummer

Rowsource:

SELECT Uitvoering.Voorstellingnummer, Uitvoering.Uitvoeringnummer, Uitvoering.Zaalnaam
FROM Uitvoering
WHERE (((Uitvoering.Voorstellingnummer)=[Formulieren]![TEST].[voorstellingnummer]))
ORDER BY Uitvoering.[Voorstellingnummer];

combobox3

controlement: rijnummer

Rowsource:

SELECT Stoel.Zaalnaam, Stoel.Rijnummer
FROM Stoel
WHERE (((Stoel.Zaalnaam)=[Formulieren]![TEST].[uitvoeringnummer]))
ORDER BY Stoel.Rijnummer;

p.s TEST is the table im working in

-pieter

 

[JHB]

Yes exactly, (and it seems to be okay), so did you checked the Column count and the Column Widths for the combo box?
If you have copied the combo box from one of the other 2 and not change property, (then I'm sure it is here the problem lays), so check if the property for the combo box shows something like below:
Column count = 2
Column Widths = 2,542cm;2,542cm

Else post a sipped version of you database with some sample data, (zip it).

 

[jan pieter]

I have checked it looks fine
i have uploaded a sample hopefully you can find the mistake

- jan pieter

 

[JHB]

Can you give me the necessary tables also with some sample value in, (because the tables in this database is linked to another database)?
The mistake is this the second combo box first column shows the value from Uitvoering.Uitvoeringnummer and this is what is set in as the criteria for the third combobox.