i am trying to change the date in this field to be the date and time currently
Code:
DoCmd.RunSQL "update Duptbl set [Date Entered Into Alvin] = now()"