Update query question

[livin''''life]

I have a table of classes like below:

Lastname Firstname class1 class2 class3

where the class field is the day that they complete the training. If a
student completes 3 training classes on Day1 and they are always the same 3
training classes, can i create an update query where i can select Day1 from a
dropdown list and it puts the date in all 3 columns.

I currently have a form where I can do this using an Onclick event of a
command button, but i have to do it for each class. I want to simplify a bit
and be able to say 'if a person completes day 1 of the training, add the date
to all 3 classes'. Not sure if i explained it right but any help is
appreciated.
Thanks

 

[pietlinden]

I have a table of classes like below:

Lastname  Firstname class1 class2 class3

where the class field is the day that they complete the training.  If a
student completes 3 training classes on Day1 and they are always the same3
training classes, can i create an update query where i can select Day1 from a
dropdown list and it puts the date in all 3 columns.

I currently have a form where I can do this using an Onclick event of a
command button, but i have to do it for each class.  I want to simplifya bit
and be able to say 'if a person completes day 1 of the training, add the date
to all 3 classes'.  Not sure if i explained it right but any help is
appreciated.
Thanks

non-normalized designs are going to cause you problems... What if you
need to add class4 (or class5?).
You can use the AfterUpdate event of the combobox and have it do it
for you.

me.txtDay2=me.cboDay1
me.txtDay3=me.cboDay1