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.

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

me.comments = me.comments & me.status

etc, etc
???
ken

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.

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