Put code in the form's BeforeInsert event, that happens when a new
record being created,
Me!WhenEntered = now()
Not to be a smart@$$, but the second of three sentences on my original
post said, "The field isn't bound to any control on my form," which
makes Bob the winner, since everyone else told me to operate on a
control! (...unless I misunderstood something.)
Now for the bonus trivia question: Bob, your code works, but I don't
understand why. Isn't the Me keyword a reference to the instance of
the class that contains the code in which it's used? Since I'm working
on the code of a form, and that form contains no reference to
WhenEntered, I don't know how Me!WhenEntered can be a valid reference!
Is it because VBA knows to look at the Record Source for the form in
this case? Perhaps it has something to do with the specific behavior
of the BeforeInsert event? Or is it that the form itself is something
like a Private Property of the table?
Thanks for your help!