sticky field

[krisleech]

Is it possible to have the deafult value for a field be set to what ever the last records input was.

eg. if i created a new record and selected "Smith" as the value for the name field, then created another new record, the default value for the name field would be Smith.
Therefore all new records have the default value as Smith until i choose a different value say "Robinson" for the name field at which point the default value would become the "Robinson".

This would greatly speed data entry if any one field is likly not to change from record to record.

Many thanks Kris.

 

[raskew]

In the control's AfterUpdate event
you could use something like:

Private Sub LName_AfterUpdate()
If Not IsNull(Me.LName) Then
Me.LName.DefaultValue = "='" & Me.LName & "'"

 

[krisleech]

Thank-you very much. Worked perfectly.
I think i need to learn more VB, or learn the properties of the objects, this stuff is simple, yet allow so much more ability for your databases.

Kris.