trying to link dropdowns
From: jefe (anonymous_at_discussions.microsoft.com)
Date: 08/12/04
- Next message: Chris Mills: "Re: multi-resolution environment"
- Previous message: Amy Vargo: "RE: Error: Cant find database specified"
- Next in thread: Cheval: "trying to link dropdowns"
- Reply: Cheval: "trying to link dropdowns"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 12 Aug 2004 15:22:28 -0700
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
- Next message: Chris Mills: "Re: multi-resolution environment"
- Previous message: Amy Vargo: "RE: Error: Cant find database specified"
- Next in thread: Cheval: "trying to link dropdowns"
- Reply: Cheval: "trying to link dropdowns"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
