form question

  • Thread starter Thread starter Lauren B.
  • Start date Start date
L

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.
 
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.
 
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.
Click to expand...

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