Pop Up comments field

[JDubya]

Hi All

I have a textbox - Forms![FrmPGFinal]![txtComments] that is bound to [tblPGFinal]![Comments], which has a Memo data type.

I have an unbound pop up form - Forms![frmPopUpComments] with a single text field – [txtInsertComment]. There is also a command button – cmdOK.

When I open the pop up form I want to be able to add some comments and then when I click cmdOK, I want to populate the Forms![FrmPGFinal]![txtComments] field with the text in Forms![frmPopUpComments]![txtInsertComment]

I would like it to be populated so that each update is placed at the top of the field and preceded by the date and the user ID. I would also like it to leave a blank line between the previous update so that the text is not all merged into one.

I know this can be done as a programmer once coded it for me in one database and I used the code for other databases as well. Unfortunately I haven’t got access (pardon the pun) to these anymore and haven’t got the foggiest ID how it is done.

Help me Obi Wan Kenobi you’re my only hope!

TIA
John

 

[KenHigg]

Something like the following in the popup form's close event:

Forms![FrmPGFinal]![txtComments] = Forms![frmPopUpComments]![txtInsertComment]
& vbcrlf & Forms![FrmPGFinal]![txtComments] & " " & date() & " " & Environ("USERNAME")

???
ken

 

[JDubya]

Thanks a million Ken, that worked a treat !!

 

[KenHigg]

Cool -


ken