I have a form for an agent to enter records in a db. Ideally, when the agent completes the record, as the insert completes, I'd like to create a way before insert or after insert of the new record that vb uses "now" to get the date/time, then insert that into the appropriate field.

Any suggestions as to how to accomplish this? Thanks for your help! :rolleyes:

Make Now() the default value of the field.