using iif to control contents of dropdown

[Guest]

hey everyone, I have a distribution table which lists company and name. i
have a datasheet that shows all fields from this table. the Company and Name
fields are setup as combo boxes, which contain all distinct entries from this
table. what i want is, if someone selects a name, i want the company box to
ONLY display the companies for which the name matches (ie Nick might be
listed as being in Company A B and H but not D E or L)
i'm trying to use an iif statement in the Query builder, as such:
iif([name] is null,"",[name])
it's not working, however... i'm not getting ANYTHING.
PLease help!!

 

[Guest]

Roger Carlson has a sample/demo of creating cascading combo boxes at
http://www.rogersaccesslibrary.com/TableOfContents3.asp#C.

 

[Guest]

Thanks so much!! That was perfect, and also gave me a ton more examples for
other problems!!

Roger Carlson has a sample/demo of creating cascading combo boxes at
http://www.rogersaccesslibrary.com/TableOfContents3.asp#C.
--
Duane Hookom
Microsoft Access MVP

hey everyone, I have a distribution table which lists company and name. i
have a datasheet that shows all fields from this table. the Company and Name
fields are setup as combo boxes, which contain all distinct entries from this
table. what i want is, if someone selects a name, i want the company box to
ONLY display the companies for which the name matches (ie Nick might be
listed as being in Company A B and H but not D E or L)
i'm trying to use an iif statement in the Query builder, as such:
iif([name] is null,"",[name])
it's not working, however... i'm not getting ANYTHING.
PLease help!!