form

[austin]

i have a form with entry fields for contact dates with clients. obviously i
don't want every date on the form. how do i have columns for the last time i
spoke with the client, a column for the current entry, and have it update the
form each time so that it only lists the last time and the current date.

 

[KARL DEWEY]

Some folks have used a DateTime, Text, and Memo field in their record to do
this.
On initial contact the DateTime and Text are filled out. The Before Update
property of the text field is used for event or call a macro that Set Value
of the memo field with DateTime and Text field data with a Chr(13) & Chr(10)
and current contents of the memo field. This results in the memo having a
cronological record of contacts in descinding order.