Sub-Forms

[David Ehrenreich]

I have a database that logs in students that come into our
office. They have a login form that they fill out. Then
their is a proctors form for us. When the proctor pulls
up that form they enter the students social. The feild is
linked to a sub-form which pulls up their test info. This
process all works fine if the student has never logged in
prior. If the student has logged before. The sub-form
pulls up the first record entered. Is their a way in the
sub-form I could have it pull up the last record entered.

Thank You
David Ehrenreich

 

[John Vinson]

Is their a way in the
sub-form I could have it pull up the last record entered.

Only if you have some value in the record that indicates the order in
which it was entered. Access has no "recordnumbers"; a Table is an
unordered bucket of data, and there is no "first record" or "last
record" in any usable way.

Consider putting a Timestamp field in the table with a Default
property of Now(); base your subform on a query with

=DMax("[Timestamp]", "[yourtable]", "StudentID = " & [StudentID])

as a criterion.