Retaining field values for next record to enter

[Guest]

I have a form where we keep track of work completed for billing purposes.
The form is based off of a table and the entries are recorded into the table.
The primary key is the job number and on occasion that may be the only field
that changes when entering a new job into record. My question would be is
there a way to have access keep the fields other than the primary key
populated with the last entry/entries without setting defaults for the fields
or using a dropdown box to create a new record for the table?

 

[Al Camp]

troubledinaccess,
Use the AfterUpdate event to set the DefaultValue for the field to what was just
entered. Then, when opening a new record, that last value will be entered by "default".
That value will remain in effect until manually changed to some other value.
For text values...
YourFieldName.DefaultValue = "'" & YourFieldName & "'"