add additional data rather than update existing

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Hopefully this is an easy question, thank you in advance
for whatever help you can offer.

I created a small Access database to hold student
personal info and test scores. I also created a form
that shows the student name and then has boxes to input
test scores (special ed tests that have multiple
individual scores for the same test). The problem is
that a student may take the same exact test 10 times a
year but when I input the new scores on my form it
replaces the previous entry rather than adding it to the
field as a new test score. I need to see all of them so
I can track progress. So basically I need add data via
this form rather than replace it. Is this possible?

Thanks again,
Ken
 
You should share your table structure which I expect is un-normalized. Each
test score should create a new record in a table.
 
How is your form linking to the table?

Use code to select a new record when you open the form or
open it in "add" mode.

Do you have a unique key index (like a primary key)field
in the table? This too will help your problem as you
cannot get duplicates then.
 
Thank you very much for your reply Duane, you have given
me a suggestion on where to go from here. I will repost
if after making a couple changes I am still in the dark.

Ken
 
Thanks Dale, you and Duane have given me a couple of
ideas. I will make some changes and if I am still
needing help I will yell for help again. You and the
other people on this forum have been incredibly helpful!

Ken
 
Ken did you ever figure out your problem. I have the same one. Could you possibly share with me what u did. It would be greatly appreciate
Ange

----- Ken wrote: ----

Hopefully this is an easy question, thank you in advance
for whatever help you can offer

I created a small Access database to hold student
personal info and test scores. I also created a form
that shows the student name and then has boxes to input
test scores (special ed tests that have multiple
individual scores for the same test). The problem is
that a student may take the same exact test 10 times a
year but when I input the new scores on my form it
replaces the previous entry rather than adding it to the
field as a new test score. I need to see all of them so
I can track progress. So basically I need add data via
this form rather than replace it. Is this possible

Thanks again
Ke
 
What is the "add mode" i have the same proble

----- Dale wrote: ----

How is your form linking to the table

Use code to select a new record when you open the form or
open it in "add" mode

Do you have a unique key index (like a primary key)field
in the table? This too will help your problem as you
cannot get duplicates then
 
Back
Top