Focus statement.

[kkarren]

I have three field in a database that need to be equal if there are no entries in them I can not get the following If statement to do what I want.&nbsp;&nbsp;It I use a simple let statement without the If statments the field will change once I leave the field.&nbsp;&nbsp;But I don't want them to change if they are already populated.&nbsp;&nbsp;Any suggestions will be appreciated.&nbsp;&nbsp;<br><br>Private Sub YSR_Test_Date_LostFocus()<br>If [SASSI_Test_Date] = Null Then<br>&nbsp;&nbsp;&nbsp;[SASSI_Test_Date] = [YSR_Test_Date]<br>End If<br>If [SPS_Test_Date] = Null Then<br>&nbsp;&nbsp;&nbsp;[SPS_Test_Date] = [YSR_Test_Date]<br>End If<br><br><br>End Sub<br>

 

[Guest_imported]

Try this:<br><br>If IsNull(SASSI_TEST_DATE) = True Then<br>&nbsp;&nbsp;&nbsp;&nbsp;SASSI_TEST_DATE = YSR_Test_Date<br>End If

 

[kkarren]

That really worked well thanks for you help