nubianqueen
Technical User
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
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