update default based on last entry

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

I have a database where many of the entries (ie. date, model no.) repeat for
30+ records. How can I set up the form so that if I enter data in a
control, it will automatically set that value as the default. This way I
can just hit enter when I reach that control again if the date is the same.

TIA
 
Fred said:
That worked great. Thanks, Allen.
Click to expand...
Please add your name to the list that want to see the last record exposed.
then Me!Thisfield.previousvalue is all that would be needed.

It would be nice if the original value of the current record was there also.

This information is there since we can enter it from the keyboard and would
save a *lot* of coding in many cases, especially if it stayed the same
through trips in and out of subforms.
 
Fred's question is exacty my question , the only difference being is I am a
access novice. have created some simple tables, queries and forms, but am
rather stuck on getting the last record to appear on the form.

Could somebody please take me through it step by step.

Any help would be much appreciated.

Thanks

Lee
 
Back
Top