Editing Records In Table Using Form

[ffezz]

Hello. I am pretty new to access and VB so I'm going to describe my database design and then give you the problem so you can tell me if there might be a better way to do it.

We are running a chess club at my school. We want to keep stats with access so I made a table with 8 fields. ID, First Name, Last Name, Rank, Wins, Losses, Draws and Win percentage.

I then created a form with two lists, and a frame with 3 buttons with the options Player 1 wins,
players 2 wins and draw. I added a button at the bottom that serves to update the database.

What I want it to do is Use the selected radio button to add a win/loss/draw to the appropriate records which are selected in each field. I will then have to re-organize the ranks for most of the entries because the rules are custom and pretty strange. When you beat a player with a higher rank than you, you move up half the difference in ranks, which will have to force all the records bellow to move down, while the player you played loses only one rank. This makes it easy to get to the middle of the list and progressively harder to get up to the top. I have no idea how to program the sub for the button click though.

Any help is appreciated.

Thank you,
Chris

[June7]

Sounds like very complicated algorithm and not something anyone is just going to 'whip out'.

Might find some applications out there you can adapt. Start with this in your search (no idea what the software environment is) http://www.enpassant.dk/chess/softeng.htm#CBLIGHT

[ffezz]

Huh I think you are misunderstanding. What i am having trouble finding is the code that will select the appropriate player from the table based on the selection in the menu. For example, if a player named "John Doe" is selected, then have the form query the table, find the player selected, and then based on the selection, add a win, loss or draw in a separate column for each

[June7]

You don't want code to do the ranking - you will make that determination and manually enter rank value?

Okay, so you want a way to find player record? Build a form with a query as RecordSource and filter the form recordset. Here is one way: http://datapigtechnologies.com/flash...tomfilter.html

The radio button usage has me baffled. I have never used radio buttons for data entry. Do you want to provide project for analysis?