If Statements in Acess

G

Girl Scout Holly

I would like to have a drop down(list box) show different info based on what
is in another field.
EX: Serivice Unit : Rising Sun

(dependant field:) School ( I would like a list box with only the schools of
the Rising Sun unit)

Any help is appreciatted
 
O

Ofer

In the RowSource Property of the combo (drop down) create a link to the
TextBox (another field)
Select SchoolName From TableName Where Area =
Forms![MainFormName]![TextBoxName]
 
Top