I don’t know what event to use. Help please.

[RJ45]

I need that Date and Time to be stored separately, But the problem I have, is I don’t want the user to have any control over the input of the Date and Time.


BUT When the user starts typing in the “notes” field, that I when I want the time and date to be automatically populated.
I've been trying to find example on this topic, but i came up empty. I need help coding this.


Any help will be Appreciated.

thank you.

 

[AlienRay]

To record the time the moment the user starts typing, use the On Key Down event. In order to make sure you're not overwriting the time every time a key is pressed, however, you first need to check to see if this is the first time something was entered. For example:

IF isnull(myTextField) = True THEN
myDateField = Now()
END IF

 

[RJ45]

Stuck on this, still wont work for me. help anyone.