Add timestamp to a record whit a add commandbutton

[lholgerg]

I have form that contains a subform where there are a lot of text fields and dropdown menues. in the buttom of the form I have a button that add's the record and gets the next one, but this button should also add a timestamp to the record.

Thanks

 

[ghubbell]

Hi Iholgerg:
Go to the table where your forms records are from. Find your date/time field, and set its default value to Now().
Any new record will therefore by default, take the time from your computers clock and you won't have to touch a key! Gord
ghubbell@total.net

 

[lholgerg]

Thanks it works great, but not when my tabels are a link to a MSSQL server where the Now() command does not exist.