showing value in text box based on list box choice

[Greg553]

What i'm trying to do is show the corresponding value based on two list box choices.

this is the set up

list box names
Player_ID
Player Name

List box Lifts
Lift_ID
LIft Type

I have a query of the weight lifting table which has the max weights for each lift for each player.

I know I must reference the text box but not sure on the syntax for doing this

any help in right direction would be great.
If more info is needed let me know

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=209099

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886