In Access MDB the expression is Now(), in SQL it's GETDATE() so have tried both in the following macro.
SetValue - ContactDate - =Getdate()
Field Name: ContactDate
On the form I have set the macro to activate on a double click. But it wont run.
Strangley if I set it to return Date() I get a response of 30/12/1899 00:04:29 no matter when I double click the field I always get that response.
Thanks for your help in advance