Question about combo boxes.

[Mitchy]

Hey, I am trying to filter around 60 000 + lines of data with the use of combo boxes. Since ACCESS is rather new for me I am now completly stuck on how to combine the combo boxes.

Lets say I have a table with this structure:

Column #1 Column #2 Column #3 Column #4
14 L10121111 Name Martin K.
14 L10121111 Date 10-10-2010
14 L10121111 Company Pie Inc.
14 L10121111 Year 2010
14 SV1019111 etc.
17 SV11918191
17 SV1019111
18 SW20101
19 LX20191013
21 SW29101
etc. etc.

I have first created a couple of queries to merge all relevant data into single lines, seeing all information can occur multiple times. I copied this SQL code into the record source which works there are nou doubles, just unique numbers in the dropdown box now.
Well I know this is very basic, but I try to be as clear as possible what kind of problem and what my knowledge is ( close to 0 yes I know but we have to start somewhere ) so that is that.

Combo box 1 (Column #1)
14
17
18
21

Combo box 2 (Column #2)
L10121111
SV1019111
SV11918191
SW20101
LX20191013
SW29101

Now what I want to do is make Combo box 2 check if there is ANY value selected in combo box #1, if none is selected it should display ALL possible data. If in combo box #1 data is selected it would be great if Combo box #2 specifies its options to the selection made in combo box #1.
I have been playing with AfterUpdate and trying to merge the SQL of the first combo box into the second one, hoping it would somehow work.

After browsing chez internets for a few hours now I decided to come back here and check out if any badass access coder is willing to help out a nibwit.

Thanks in advance

 

[tezread]

I think what you are asking for is cascading combos?

do a search for cascading combos and see what you find good sir