Comments Box with Username

[David Bratby]

Hi,



I have a form with a combo box with a list of user names, a comments box and a history box.

I have set the comments box to append and the history box uses

=ColumnHistory([RecordSource],"Notes","[ID]=" & Nz([ID],0)).

This displays the history of comments box with a time stamp perfectly.

What I would like to do is somehow record the the username with the comments.

Is there a way to do this? or an alternative way of doing it?

Thanks in advance,

Dave

[ItsMe]

You could create your own VBA code to store the comments in another table. The Memo field is going t do stuff via intrinsic tools within Access. The intrinsic Tools have limits. I do not believe it will do anything more than what you have discovered. You may be able to use both the intrinsic tool and a separate table. The separate table would manage aspects that the intrinsic tool does not. Or a separate table with VBA code can manage the whole thing.

[NTC]

I can't actually follow your post very well - so this advice may be off key; but what one might do is add a new unbound text field 'Add Comment'

and have the user enter their comment into this new field - then on a trigger event , such as exit or afterupdate or a command button....write in the unbound Add Comment field into the actual Final Comment field along with the User Name field ......

[HiTechCoach]

This was also cross posted here: http://www.access-programmers.co.uk/...00#post1461500