Automatically Fill In Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick - 14 May 2008 16:37 GMT

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.

Reply to this Message

Beetle - 14 May 2008 17:33 GMT

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.

Signature

_________

Sean Bailey

> 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
[quoted text clipped - 7 lines]
> so I need to have the ranking save in a query if possible so I can use it
> when it the applicant rating formula.

Reply to this Message

Nick - 14 May 2008 18:31 GMT

Thanks for the help!

> There are several ways you could do this, but saving the ranking
> redundantly in another table is not necessary.
[quoted text clipped - 17 lines]
> > so I need to have the ranking save in a query if possible so I can use it
> > when it the applicant rating formula.

Reply to this Message