Populate new record with old data

N

Navaid Mansoor

I have a tble which needs to be updated daily, most of
the times the new data is the same as the one on last
day. Now, instead of typing in the new data, i wish the
new records to be populated with the one on the last date
(except the date field, which will be entered by the
user).
Can anybody help me out with this?
[email protected]
 
S

Steve Schapel

Navaid,

A couple of thoughts which might help...

There is a keyboard shortcut Ctrl+' to enter the same value in a form
control as in the same field in the previous record.

You could put a command button on the form to run an Append Query which
adds a new record the same as the most recent record in the table, but
with the current date.
 
Top