Trying to create an If steatement thet popoulates aa unbound text box in access form

[deanamiles86]

i have created a If Statement that should update an unbound form with the information from another unbound form depending on what number is entered

Private Sub Form_AfterUpdate()
If Me.Text6 = 2 Then
Me.Text11 = "Me.SAPR"
Else
Me.Text11 = "Now()"
End If
End Sub

but when i enter the number the field remains blank

please help

[Seth Schrock]

The first thing that I notice is that you have your code in the form's after update event. This won't trigger until you go to another record which can't happen in an unbound form. Try putting your code in the after update event of the control that you are updating.

[zmbd]

second thing is that you have no reference to a different form for a value to return/set. You should also include code to check that the form is open or you will encountere another set of Grimlins.

[deanamiles86]

Thanks Seth working now cant believe I missed that!!!