"I posted this in forms as well need help real bad"

[Bears84]

I have a form base on 3 tables. I am trying to get a text field on the form to have the word "No" inserted if there is nothing in a text field associated with.

Scenario:

If [coordinator name] is blank then [Approval] equals "No"

 

[addy]

OK, assuming you need to have the [Approval] text box to become blank after something is entered into the [coordinator name] field then try the following:

In your Form's OnCurrent Event use the following:

If IsNull(Me.[coordinator name]) Then

Me.[Approval] = "No"

Else

End If

Then, in the AfterUpdate Event of the [coordinator name] field use the following:

If IsNull(Me.[coordinator name]) Then 

Me.[Approval] = "No"

Else

Me.[Approval] = Null

End If

Should work!