opening form to new record with last entered date (1 Viewer)

[petertmpl]

in office 97 i created a form which opens to a new record using a macro. i want the date field to open with the last date entered, can do it by Ctrl-' , how can it be done automatically as the form opens a new record. any suggestions?
Thank you.