form filling a table

[Greg553]

Hello,
After some great tips from this site i have corrected the problems.
I'm trying to figure out if it is possible to have a form with multiple text boxes fill in a corresponding table.

This is what I have

Player information table ( tbl_playerInfo)
Weight lifting record table ( tbl_WeightInfo)

My form consists of a combo box getting the names from the Player Info table, and storing the player ID in the weight Info table, that works fine.
I also have a combo box of lift types and a text box for weight lifted. I choose a lift enter the weight and it fills the table just fine.

Now my question is this. We track 10 different lifts and with 50 players that is a lot of entering, pulling up each lift in the combo enter weight etc.

Is it possible to have multiple combo / text boxes so i can choose a different lift in each combo box and enter them all at once and still fill the table.
Or can you you have text boxes with each lift name and enter the weight there and populate the table.
thanks
Greg

 

[dhookom]

You can have a continuous subform where you select the lift type and enter any other information. The subform will link to the player primary key from the main form.

Duane
Hook'D on Access
MS Access MVP

 

[Greg553]

Thanks, I understand now.
Greg