Retaining field values for next record to enter

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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 & "'"
 
Back
Top