is this smart form possible?

[ariansman]

There is a table named “ student_score” like the following:

ID   studentname       score           subject

12        jack           A             Biology    
13        jack           c             politics    
14        jack           B             math    
15        jack           A             physics   
16        Steve          B             math
17        Steve          A             politics

The data is recorded by a form named: “score_entery”. Is it possible that when I open the form all three fields are blank and ready for data entry, but when I put next and the form goes to the next record, the student name field automatically gets the data of the previous record? if this works I wont have to choose student name after the first record and i will only put the subject and score.
Thank you

 

[AlexN]

At a very first approach you could simply press CTRL + " to repeat the above value in the studentname field . But I'm sure there are several other ways.

 

[Minty]

Use an after update event to set the default value of the field on the form.
Then requery / refresh

 

[spikepl]

After update of the control. And requery/refresh is unnecessary - the default applies to the next record, not the current one.