trying to link dropdowns

[jefe]

I have a subform that requires entries into a
table, "Subtype".
The listbox used as a row source should be populated
based on a previous entry into table, "Type".

The entry into the "Type" table is based on a rowsource
table, "Zlookup: Type".

I have another zlookup table, Zlookup: "Subtype" that
lists all of the Types and their associated Subtypes. I
am trying to use this table as the source data for
the "Subtype" list box.

Trying to decipher other sources, the following is what I
came up with for the row source line in the property box
for the subtype subform - and it doesn't work.

SELECT [Zlookup: Subtype].Subtype, [Zlookup:
Subtype].Code FROM [Zlookup: Subtype] WHERE
((([type].Type)=([type].[type])=[forms]![type]![type]));

I am totally confused.
Please help

 

[Cheval]

Confused? Me too. Could you re-read your posting as your
sentence gramma is hard to read and understand.

Your select statement looks wrong as well. If it is
correct, then I would remove the spaces and the colon
(":") from within the table name. I usually make lookup
tables look like "zluSomeTable". Z so it's at the end of
the table list and lu for LookUp. For ease of readability
and logical groupings sometimes tblTable_1_Name,
tblTable_2_Other, tblTable_3_Something.