Setting and keeping original date/time

[Stephenn]

I've got a two fields called [Type] and [Date Submitted]. I use:

Private Sub Type_Change()
Date_Submitted = Now()
End Sub

to create to populate [Date Submitted]. However, I don't want [Date Submitted] changed every time I change [Type]. I would like to create my record, select a type having [Date Submitted] populated with the date and time, and for [Date Submitted] to keep that date no matter how many times I change [Type]. I realize that "On change" is not the event I should be using to accomplish this, but I don't see any other event I can use or a "can change" property. Maybe vba is the way to do this. Any suggestions?

 

[Fizzio]

To populate [Date Submitted] and it not to change depends on when you want to populate the field. If you want to populate it when a new record is created, just set the default value of the control in form design to =Now(). It will then remain the same no matter how many edits you perform. If it is not a new record, it will require a bit of coding. Let me know if this solution is not what you want.

 

[Stephenn]

Thanks, that worked for me. I have to laugh at how often I overlook the obvious. Thanks again.
Stephen