Update query question


L

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
 
Ad

Advertisements

P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top