How to clear a field when another field is Null

[alosbanos]

Hello,



This is a newbie question, but I have a form with field [Status]. When [Status] is set to "Will Attend" I can input the country of birth in field [Country_Birth]. My question is there something where if [Status] field is set back to null field [Country_Birth] will automatically clear?

Thank you,
Asuncion

[Robeen]

Click on your Status field.
Open the Property Sheet.
Click the Event Tab.
Click in the Lost Focus Row.
Click the [...] on the right.
Choose Code Builder if prompted.

The code window that opens will look something like this:

 
Private Sub Status_LostFocus()
 
End Sub

I haven't tested this code - but let me know if you have problems with it.

Type something like this between those two lines:

 
Me.Status.SetFocus
If Len(Me.Status) < 1 Then
    Me.Country_Birth.SetFocus
    Me.Country_Birth = ""
End If

[RayMilhon]

Depending on the Actual Value of me.status this will not work as expected. If me.status is null len(me.status) will return null. Use this instead this will account for all possibilities.

If IsNull(me.status) or len(me.status) < 1 Then