form question

[Lauren B.]

How can I set up combo boxes so that the box 1 dictates what appears in box
2? For example... box 1 will contain that name of states- once a state is
selected, box 2 will contain all counties for that state.

Thank you for your help.

*I apologize if this is a repeat post... I've been having some trouble
getting my messages to appear.

 

[Tomas]

In Combo1 AfterUpdate event write

Combo2.RowSource = "SELECT County FROM Counties WHERE State = ' " & Combo1 &
" ' "
Combo2.Requery

Table and field names in the SQL statement are just examples.

 

[fredg]

How can I set up combo boxes so that the box 1 dictates what appears in box
2? For example... box 1 will contain that name of states- once a state is
selected, box 2 will contain all counties for that state.

Thank you for your help.

*I apologize if this is a repeat post... I've been having some trouble
getting my messages to appear.

See:
Forms: Limit content of combo/list boxes
http://www.mvps.org/access/forms/frm0028.htm