Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DateStamp New Data in Form

Status
Not open for further replies.

nubianqueen

Technical User
Apr 16, 2002
19
0
0
US
This is not exactly what it sounds like. I have a pop up form called Comments. It is a table on the many side of a table called Policies. I split it up because there can be many comments for one Policy. I have code set up so when a user double clicks on the policy# in the Policy form the comments form comes up. The control source for Comments is a query. Each time a new comment is entered for a existing policy it is to be date stamped.
I did have a field called DateStamp in Comments table and the policy# as well, but what happens is when I try and enter a new comment for a exisiting policy the date is not changed and the new comment is in the same field as the previous one.
I hope this makes sense to someone, any help is greatly appreciated.
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top