list box writing data to table 1

[Greg553]

Hello, i will try to explain the best i can.
I have a form that has to list box controls onit
Listboxnames
Listboxlifts

the listboxnames is populated with names from a table containing the names of players.
when you click on a name in the list box the after update code runs and populates the listboxlifts with any max effort lift on record for the player.
This code all works fine, but a problem occurs when you have moved to a name and you close the form. for some reason the program writes that players ID over the last record or player ID of the last record in the list.
I am not changing any information only clicking on the names to update the other list box.
How do i go about stopping the program from doing this.
If more info is needed please let me know

thanks
Greg

 

[MajP]

Your first list should be unbound (no control source). You have it bound to a table or query.

 

[Greg553]

with out even going into the program, you are right...
thanks for the info i will do that
Greg