subform question

[Guest]

Hello,

I would like to create a subform on a form in a database with contact
information. The subform would be to add notes for a contact. I would like to
be able to start typing the note and have the date and time and the user
display automatically. I have seen this done on another database and was
wondering how difficult this would be to implement. I would have a memo
field, a field for the date and time, and a field for the user. When I start
typing in the memo field, the date and time and user field would populate. I
think I can figure out the date and time but how would I accomplish having
the user name field populate. This database will be in a folder on a server.
I am using Access 2003.

Thanks in advance for any help.

Best regards,

Dee

 

[Ken Snell \(MVP\)]

Use the BeforeInsert event of the form that is serving as the subform to run
code that writes the information into those textboxes in the subform.