Linking fields in a table

[Guest]

In a form I want to type in a school from my Schools table and the office
info from that same table will automaticley pop up on the form for each
school name. Can this be done?
Katherine

 

[Guest]

I've done this in a couple of forms. If the School name is the Primary Key
then this is simple. As long as the forms Record Source includes that
information, once you finish typing and that box Loses Focus it should update.