update default based on last entry

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
 
M

Mike Painter

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.
 
E

exoatcake

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
 
Top