If Statements in Acess

G

Guest

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
 
G

Guest

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top