get value out of referencetable

[Ankie]

Hi people,

I have made a form, with the fields 'age' and 'score' (and other fields, but these are not relevant for my problem).
The 'age' is automatically filled in, and the 'score' has to be entered.

Now I want if you have entered the 'score' to get the right value in an other field in the form. That value has to be from the referencetable.

The referencetable looks like:

score ->
age 1 2 3 .....
0-10 bad good good
10-20 bad bad good
20-30 bad bad good
30-40 bad bad bad

I have not yet made the referencetable in Access, because I don't know how I can best made that table... like above, or on another manner...

Thus if age is 25 (stays in the form already) and you fill in the score of 2.. if you press than on a button (for example) the value 'bad' has to be filled in in another field in the form.

I hope it is understandable what I want..

Thanks in advance,

Ankie

 

[Ankie]

Can maybe someone help me with this? Or has someone a better suggestion how to do this?

Hope to hear from you soon...

Thanks, Ankie

 

[MStCyr]

Hi Ankie

I'd love to help but I'm having difficulty understanding what the requirements are. I would suspect that this is the problem with the rest of the group.

 

[Ankie]

it's already done...