Latest Date on the main form

[Ang]

Hi ,

I check Access 2002 and it works but not Access 97. I am making it work on
Access 97. I have main form with two subforms. I am not too sure if I did
wrong on the code. I will be appreciated your feedback. Thanks....

Main Form : txtstatus

SubForm#1: txtDate3

SubForm#2 : txtDate4
txtDate5
******************************
Private Sub Form_Load()
txtStatus = "No dates yet"
End Sub

Private Sub txtDate3_AfterUpdate()
If txtDate3 > Nz(txtDate4) And txtDate3 > Nz(txtDate5) Then
txtStatus = txtDate3
Else
MsgBox "This is not the latest date"
End If
End Sub

Private Sub txtDate4_AfterUpdate()
If txtDate4 > Nz(txtDate3) And txtDate4 > Nz(txtDate5) Then
txtStatus = txtDate4
Else
MsgBox "This is not the latest date"
End If
End Sub

Private Sub txtDate5_AfterUpdate()
If txtDate5 > Nz(txtDate3) and txtDate5 > Nz(txtDate4) Then
txtStatus = txtDate5
Else
MsgBox "This is not the latest date"
End If
End Sub
*********************************