Originally Posted by
June7
date/time data goes into Date/Time field.
Now() returns a full date and time value.
Date() returns the date part (time part will not show and would be all 0's if it did)
If you don't want user to select value for [date/time stamp] field then don't reference a textbox. Just reference the Now() or Date() function in the SQL.
Regardless of which you use, don't use apostrophe delimiters when field is date/time type.
BTW, advise not to use spaces nor punctuation/special characters (underscore only exception) in naming convention.