On First Change Only

[Risto85]

Hello



I've created a macro which fills date and time in specific fields. Now I've assigned this macro to Text Box, so when text box is filled then current date and time in fields next to it will be added. I've used event "On Change" for that. Problem is that I don't want this date and time to be changed later on when text box field will be changed. How to solve this? Is there some event feature "On First Change"?



Risto

[ranman256]

I dont see the need for macros to fill in fields when you can use DEFAULT VALUES.
or
use pick lists that can autofill.

[John_G]

You could modify the macro (or use VBA) to update those fields only if they are Null.

[Risto85]

ranman256 - timestamp is needed at the time when field will be edited, record could be open, but if nothing is inserted then I don't need timestamp.
John_G - Yes, I was also thinking that solution would be to modifty macro to update only fields if they are null.


Risto