Combining 2 combo boxes in a form 3rd part

F

Fischkopp

Hi Klaatu and Allen (and all the others)

thank you both very much for your support yesterday.
I used the way Klaatu described yesterday (Allen confirmed the steps too
yesterday)
BUT...

(Major Columns: COUNTRY and POSITIONCODE .....34 addition. columns)

I designed a Totals query with the GroupByOption. It worked fine on my 1st
combo box.

But I was not able to use following step for my 2nd Query:

To do that,
in the COUNTRY column Criteria, reference the Country combo:
forms!MyFormName!MyCountryCombo

Using the EXPRESSION Builder I put:

Forms![>PosCodes]![Combo324]

into the CRITERIA field in the COUNTRY column but all I get is a PARAMETER
box opening...

NOW, after nearly 5 hours trying I was able to enter the CRITERIA into the
COUNTRY columnas follows:

[Forms]![>PosCodes]![Combo324]

My problem is that not every COUNTRY (1st column) has not the same POSITION
CODES (2nd column) . The construction works fine until I select another
company than the first company in the list.

AIM: The 2nd combo box shall only show these POSITION CODES belonging to
the selected COUNTRY of the 1st combo box.

Thank you very much for your support again. I will be really grateful.

Best regards

Fischkopp
 
Top