You need to add the timestamp field to the table (datatype date/time) and a
textbox to the form bound to that field. In this case I named that textbox
txtTimeStamp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads: http://www.datastrat.com http://www.mvps.org/access
The date that needs monitoring of the last modification is being filled by
the input date function in the date picker I found on http://www.mvps.org/access/forms/frm0057.htm
My best guess it that it has something to do with that ...
code on click event calander button :
Me.txtEndDate.Value = InputDate("Select End Date")
code in before update on the monitored date
is as Arvin suggested
Hope this helps you more
thanks
Fie
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.