Keith's advice is correct. Remove what you entered in the textbox's
AfterUpdate. Set the textbox's Locked property to Yes or Visible property to
No to prevent the user from manually editing this time. Set the
ControlSource of the textbox to the field you want to store the date/time
in. Make sure you add this field to the query that is supplying the data to
the form's RecordSource.
Once you do all of this and adjust the name of the textbox in the code that
Keith gave you to match the name of your textbox, it should work. Place the
statement after any statements that you may have in the form's BeforeUpdate
event that would Cancel the update (if any).
--
Wayne Morgan
MS Access MVP
<fo*******@martecgroup.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...
When I add that in the before update I get a "you can't go to a
specified record" box that pops up. Only option is to click "ok" and
it goes back to the same form with the same record. I do have a save
record button on the form where it asks the user if they want to save
the record and move onto the next or cancel. If that helps clear things
a bit. Thanks.