combo boxes

[Lauren B]

I need to have one combo box that contains a list of all state abbreviations
as a value list--when the user selects a state, I want the next combo box to
contain only the counties within that state. I have a table with states for
the first column and counties as the second column. What is the best way to
do this?

Thanks for any assistance.

LB

 

[Guest]

hi.
this is call cascading combos.
see these site for more info. in the first site, scroll
down to cascading combos.
http://www.rogersaccesslibrary.com/TableOfContents3.asp
http://www.blueclaw-db.com/filter_combo_box.htm
http://www.mvps.org/access/forms/frm0028.htm

 

[fredg]

I need to have one combo box that contains a list of all state abbreviations
as a value list--when the user selects a state, I want the next combo box to
contain only the counties within that state. I have a table with states for
the first column and counties as the second column. What is the best way to
do this?

Thanks for any assistance.

LB

State abbreviations as a Value List? Why?
You already have a table with all the state names and their counties,
right?

Set the RowSourceType of the first combo box (cboStates) to
Table/Query.
Set it's Rowsource to:
Select Distinct tblCounties.State from tblCounties Order By
tblCounties.State;

Leave the Rowsource of the Counties combo box (cboCounties) blank.
Code the AfterUpdate event of the cboStates combo box:

cboCounties.Rowsource = "Select tblCounties.County from tblCounties
Where tblCounties.State = '" & cboStates & "' Order By County;"