Unbound Combo Box Displays Fields based on a Relationship - how to?

[amywolfie]

There is a feature in FileMaker which allows you to create a
relational value list (i.e., values which populate the list are based
on a relationship).

Is there an equivalent in Access 2007?

I have a Find control -- unbound combo box for States (cboState)

I need another Find control -- County -- preferably another combo
(cboCounty) which displays only those counties linked to a given state
once it's selected in cboState.

I do have PK_State from tblState linked to fk_State in tblCounties in
a one-to-many.
Relationship is OK -- I need the technique for a relational combo.
Can be Access, VBA, etc.

Thanks!
===

 

[John W. Vinson]

There is a feature in FileMaker which allows you to create a
relational value list (i.e., values which populate the list are based
on a relationship).

Is there an equivalent in Access 2007?

I have a Find control -- unbound combo box for States (cboState)

I need another Find control -- County -- preferably another combo
(cboCounty) which displays only those counties linked to a given state
once it's selected in cboState.

I do have PK_State from tblState linked to fk_State in tblCounties in
a one-to-many.
Relationship is OK -- I need the technique for a relational combo.
Can be Access, VBA, etc.

Thanks!
===

This is very common and pretty easy in Access - the jargon term is
"conditional combo box" or "dependent combo box".

Basically you use a Query as the rowsource of the dependent combo, which uses
the value of the first combo box as a criterion. A couple of ways to do this
can be found at
http://www.mvps.org/access/forms/frm0028.htm
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com