After Update

Hi,
use Before record added/updated events on the Events tab for this purpose.

Here is a sample:

if dict("FieldName")<>"" and dict("FieldName")<>0 then

Thank you Jane so much,
I have another request.
I would like name of user will be automatically populated on Name. Since they are logged in under their profile, per example, on the form, there will be fields that have Team, Date, Name and Comment, when the user try to add a comment, their name will be automatically populated. I tried to the code below but did not work for me
Table that hold users : tblUser

Table will information be insert to : tblcomment
Note : sAgentname Field on tblcomment

Name field on tblUser
Sub BeforeShowAdd(xt,templatefile)

str = "select name from tbluser where USERID='" & SESSION("USERID") ) & "'"
Set rsTemp = server.CreateObject("ADODB.Recordset")
rsTemp.open str, dbConnection

Session("sAgentname") = rsTemp("Name")
rsTemp.Close : set rsTemp = Nothing
End Sub ' BeforeShowAdd
Thanks Again

Hi,
please see my changes in your code:

str = "select name from tbluser where USERID='" & Session("UserID") & "'"

where USERID is your actual field name where login name is stored.
Then set up Session("sAgentname") as default value for sAgentname field on the "Edit as" settingsdialog on the Visual Editor tab.