OK. For our example here...Text20 is your field 20. Like the others before
said: Create a new field in your table. We will call it FieldA.
Now open the form in design mode.
Create a new Texbox on your form...we will call it Text21 for our purposes.
Set the ControlSource equal to the new table field (FieldA) and the Locked
property of to True.
Now back to Text20...In the AfterUpdate event of Text20:
Private sub Text20_AfterUpdate()
'Check to see if a value already exists,
'if not enter the current system date
If Nz(Text21,"") = "" then
Text21.locked = false
Text21 = Date()
Text21.Locked = true
End If
End Sub
Basically this is what Svetlana was trying to explain to you before.
jmonty