replicate data when entering

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

In a data entry form, I want to "remember the date" after
the prior record was added and populate on new form. Know
I've done this in the past, but am having a brain freeze!
 
In a data entry form, I want to "remember the date" after
the prior record was added and populate on new form. Know
I've done this in the past, but am having a brain freeze!
Click to expand...

Set the DefaultValue property of the textbox in the Form's AfterUpdate
event:

Private Sub Form_AfterUpdate()
Me!txtDatefield.DefaultValue = """" & Me!txtDatefield & """"
End Sub

The quotes are needed; even though it's a date field, the defaultvalue
property must be Text.
 
Back
Top