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,

Phil

ohhhhh!! arrrr!! screams and runs away horrified

nah only kidding. your problem is mostly that you are recording the swim level in the same table as thier personal information. this should really be in another table called SwimLevel

This table should have fields

SwimmerID (or what the key is for Swimmer)
SwimLevel
DateAttained

the key for this table is SwimmerID and Swimlevel (assuming that you can only attain a level once)

Base a form on swimmer (remove fields you dot want) and place a subform on that form using the wizard selecting SwimLevel as the datasource. When prompted use the swimmerID as the link. When you look at the form for each swimmer you shoudl see in the subform the levels they achieved.

let me know if you have any troubles

Haz.