Help at your liesure

[outlaw318]

I am trying to create a db to keep track of my fantasy football stats. I have all my tables, I am stuck trying to find the right way to set up what I would like to do. I want to add all my players stats by play week so I can keep their stats along the season. I have 10 players but can only start 7. I am trying to create lookup option that when I select to player from the drop down box it fills in the rest of the fields and I can only caclulate the fileds from the records showing. I have tried doing this in a query, but its not working out.

 

[GaryC]

I am sure somebody can help if you give more details, or ask a specific question ?, or even post an example of the code that is not working ! But it might be difficult to second guess what you have done so far !