Viewing previous data entered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Can someone help me on how I can view the last entry that was entered onto
the form. I have a field "VP reference" which is my primary key so when I add
in a new entry with a new VP reference it gets sorted automatically and
therefore it does not allow me to see the last record entered on the form all
i can see is the last record once the field gets sorted automatically, as I
need to use this VP reference to determine the next VP reference when a new
data is being entered.

Could you also tell me how I can stop my mouse scrolling as it keeps jumping
to different records when i'm adding a new record.

All help appreciated..thanks
 
Kushum,

Can you give some examples of the data that is entered in the VP
Reference field, and how the value of the VP Reference is determined by
the last one entered? If the value of the VP Reference data itself
cannot be used to identify the last record entered, then you will
probably need to add another field, with Date/Time data type, and set
its Default Value property to Now(), so that you can use this to
identify the most recently created record.
 
hi,

for example under Vp ref: i have
000123
000124
BOE(Paul)
X(Tim)

As you can see the abopve reference numbers are automatically sorted and I
want to now add 000125 but this appears in list as follows:

000123
000124
000125
BOE(Paul)
X(Tim)

But I need the 000125 to appear after X(Tim) so i can see what the last
record was in order to determine the next VP Ref. So the next VP ref will now
be 000126.
I hope I have explained myself.
thnx
 
Kushum,

Ok, well I think the best plan is to do what I suggested before, with a
DateCreated field in the table so you can always determine the most
recent record.
 
Back
Top