date time stamp a memo field

[david]

I have a memo field that I would like to click a button
and have a box come up that we can enter text and have it
go to this memo field with a date time stamp on it. This
is so we can have text entries made to the memo field and
see when they we made... We are trying to build a call
tracking database...

 

[david]

This is what I want to do.. I guess I need to create a
table with a memo field and a form for that. then a query
for an append? I would like the date time to appear on
the main form after the append is made... Thanks for your
help.

 

[Kevin]

Another approach would be to have two fields in the
underlying table. One a memo field and the other a
datetime field. Put a listbox on your form with a query
being the rowsource. Doing this you could still use your
popup box to add data and use the list box only for
display purposes. Doing this would also give you an easy
way to go to any detail records you might have on each
call. You could select a record in the list box, then
press a command button and have it display any detail
information on the call you might want to provide.

Hope this helps!

Kevin