Tracking comments in sub-form

[MOGSY via AccessMonster.com]

I have created a database tracking tasks in our department. There is a main
table (tblTasks) and a related table (tblComments). There is a one-to-many
relationship (one task per many comments). My form (frmModifyTask), is based
on tblTasks. There is a subform included based on tblComments. I have set the
subform to continuous form, read only. I have an unbound text box on
frmModifyTask named NewComments. I would like the user to be able to enter
new comments in the text box and have those comments go into the read-only
subform when the form is closed or they move to another record. How can I do
this?

Thanks!

 

[golfinray]

The comments won't go in if it is read only. You would have to un-read only,
put in the comment, then save and return to read only. It might be better to
just make it not read only and work out a save each time directly to the
table so that the comments would not be lost.

 

[MOGSY via AccessMonster.com]

The comments won't go in if it is read only. You would have to un-read only,
put in the comment, then save and return to read only. It might be better to
just make it not read only and work out a save each time directly to the
table so that the comments would not be lost.

I have created a database tracking tasks in our department. There is a main
table (tblTasks) and a related table (tblComments). There is a one-to-many

[quoted text clipped - 7 lines]

Thanks!

Thanks. Not exactaly what I was looking for... I would really like to be able
to track all comments (with date/time stamp), and not have them be able to be
modified. Any other suggestions?