Auto fill date into unbound text box

[data808]

Ultimately, I would like this date to be recorded into the table with the record but if its too hard, then unbound is fine too.

I have a form that I would like to have a date filled in to one of the unbound text boxes if one of the other fields is entered with data. How do I get this done? Just the date is fine. I don't need the time.



Thanks.

[trevor40]

Just set the Default value to Date() for the field and set the format to what you want.
works the field bound or not.

[Missinglinq]

Just set the Default value to Date() for the field and set the format to what you want.
works the field bound or not.

That will place a date in the target textbox regardless of whether the first textbox is populated or not!

This kind of thing should do:

Private Sub FirstTextboxName_AfterUpdate()
 
 If Nz(Me.FirstTextboxName, "") <> "" Then
  Me.TargetTextbox = Date()
 Else
  Me.TargetTextbox = Null
 End If

End Sub

Linq ;0)>

[data808]

This will do just fine. Thanks so much. Thank you also missinglinq.

[Missinglinq]

Glad we could help!

Linq ;0)>