S
sword856
Hello all, I have a problem with updating on my form.
I have a form, TrainingHistory, that is linked to a table by the same
name. There are three fields showing: FullName, ClassName, and
DateTaken. For each person, I am only interested in the MOST RECENT
date they took any given class. So what I want is to be able to enter
a name and class, and have Access check the table for this combination
of name and class. If such an entry already does exist, I would like
the form to bring up that entry, and that entry alone, for editing of
the date. There should also be a message explaining what just
happened. I was thinking that there should be some procedure in the
BeforeUpdate event that does this, but I have no idea where to begin
with the code for it. For bringing up the record, I was thinking that
if a record were found, the form could just bring up all records but
apply a filter with the values that were already entered.
My form is set to data entry=yes and is in Single Form view.
I have a form, TrainingHistory, that is linked to a table by the same
name. There are three fields showing: FullName, ClassName, and
DateTaken. For each person, I am only interested in the MOST RECENT
date they took any given class. So what I want is to be able to enter
a name and class, and have Access check the table for this combination
of name and class. If such an entry already does exist, I would like
the form to bring up that entry, and that entry alone, for editing of
the date. There should also be a message explaining what just
happened. I was thinking that there should be some procedure in the
BeforeUpdate event that does this, but I have no idea where to begin
with the code for it. For bringing up the record, I was thinking that
if a record were found, the form could just bring up all records but
apply a filter with the values that were already entered.
My form is set to data entry=yes and is in Single Form view.