Automatically Fill In Data

[Nick]

Okay, so I have a form in which I have to enter a University and a ranking
for the University. All of the Universities and their rankings are located in
a seperate table that I pull the information from. I want to have a
form/query automatically enter the correct ranking that is associated with
that school. I've got my form set up to pull the data in and match the school
and the rank, but it never saves it anywhere. Is there some way I can create
an expression to enter the correct ranking based on the University entered?

If it helps any, the ranking is used again in a formula to rate applicants,
so I need to have the ranking save in a query if possible so I can use it
when it the applicant rating formula.

 

[Beetle]

There are several ways you could do this, but saving the ranking
redundantly in another table is not necessary.

If your form has a combo box control for selecting the University, then you
could add the ranking field to the rowsource of the combo box, then use
the Column property to refer to it.

Alternatively, you could use DLookup in an unbound text box. If you need
to use it in calculations elsewhere, it could be added to a query, etc.

 

[Nick]

Thanks for the help!

There are several ways you could do this, but saving the ranking
redundantly in another table is not necessary.

If your form has a combo box control for selecting the University, then you
could add the ranking field to the rowsource of the combo box, then use
the Column property to refer to it.

Alternatively, you could use DLookup in an unbound text box. If you need
to use it in calculations elsewhere, it could be added to a query, etc.