Machine locking up when deleting record

[Dave Edwards]

Hi, very new to this board, and also to access (2 weeks). not sure if this will turn out to a table problem, but it occurs when using forms - hope you can help.

I have tried to create my first app which is fairly simple

It is to hold data for fishing competitions by team/player/weight etc. I have set up three tables as follows;

tblCompetition
1. CompetitionID (primary key)(Autonumber)
2. Name of Competition
3. Date of Competition
4. Location of Competition

tblTeams
1. TeamsID (primary key)(Autonumber)
2. CompetitionID (foreign key from tblCompetition)
3. Team Name

tblPlyers
1. PlayersID (Primary key)(Autonumber)
2. TeamsID (foreign key from tblTeams)
3. Player Name
4. #fish
5. best lb
6. best oz
7. Brown/Rainbow
8. Bag lb
9. Bag oz
10. Bonus units } These two are multiplied together as a bonus and are added
11. Bonus x oz } to bag lb/oz in a calculated field to give a total weight

When I use the wizard to create form using the above fields it does so with a main form, and two sub forms - just as I want.

Now the problem. If I enter test data into the form, and then try to delete it, I can delete individual entries for players without problem, but if I try to delete a team then the machine locks up with the message calculating... on the bottom left hand side. This is repeatable.

Any advice please, I am desperate to get it working - and have previously already added queries and reports, but discovered this 'problem' when testing the application.

I hope that I have explained the problem properly. Thanks for any help

Dave