Add comments:

[mr moe]

Hi Alli,
I have a database that has a comments field. The database has a status field: Plan Test and Run,
in the comments field the user adds comments, i'm trying to updated the comments with the status, for example; the user added some comments like. "The test will begin next week" I want the comments feild to automatically get updated when the user changes the status for example to Run, I want the "run status to be added to end of the comments line" can somebody help? Thanks.

 

[KenHigg]

On the status control afte update could you do something like:

me.comments = me.comments & me.status

etc, etc
???
ken

 

[KeithG]

Proper table design would be to move the comment field to a new table and create one-to many relationship between the old table and the new. Becuase is sound like on entity can have many comments.

 

[Zigzag]

Just to add to Kens Post

To put the status change on a new line.

me.comments = me.comments & vbCrLf & me.status

or to add the date & time as well

me.comments = me.comments & vbCrLf & Now() & me.status

Garry