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

[thebigthing313]

You can set the name field to have a Default Value of

=DLast("studentname", "student_score").

[June7]

DLast() is not the most reliable domain aggregate function and domain aggregate functions can be slow performers.

Could just set control's DefaultValue property with the value just entered: review http://access.mvps.org/access/forms/frm0012.htm

[Dal Jeanis]

The best way to do this is to have a form/subform setup, where you enter the student name on the master form, and then enter the grades on the subform. The subform wll be based on a query against the same table, limited to those records for that particular student.

And, I HOPE that on those grade records you're using the student ID number - an autokey field, key of the student table, automatically generated by Access - rather than the student's name. Otherwise, you are setting yourself up for a horrible experience. Ditto goes for the class/subject name.

(Sorry - here I go answering the question you SHOULD have asked, rather than the one you DID ask.