I'm not sure if what I want is an update query or a subform or or something else.
I'm the volunteer registrar of our swim club and have built a database (that would probably horrify someone who knows what they are doing) to store our swimmer info. I have a table called "Swimmers" that contains most information including their swim level. The level is selected from a combo box with a row source of another table containing only a list of swim levels.
I want another form I will call "move up" which will have only the swimmers name, their current level, their new level and the date of their move.
So far I have tried building a form based on my "Swimmers" table with the wizard, draging the name field and 2 combo boxes based on the swim level field from "Swimmers" then selecting the choice to "store this value" in the swim levels field for the second combo box.
As you might have guessed I have not achieved my hoped for results. The swim level field in my swimmers table remains unchanged.
Thanks for any help,