Data of one field to another

[Dimitris]

Hello.
In a form I have three fields F1 and F2 and F3. What I need is that whenever
the word "OK" is entered in F2, I need the data of F1 entered in F3. But only
if OK is entered in F2.
Can someone please help?
Thank you
Jimmy

 

[Brendan Reynolds]

Hello.
In a form I have three fields F1 and F2 and F3. What I need is that
whenever
the word "OK" is entered in F2, I need the data of F1 entered in F3. But
only
if OK is entered in F2.
Can someone please help?
Thank you
Jimmy

Private Sub F2_AfterUpdate()
If Me.F2 = "OK" Then Me.F3 = Me.F1
End Sub

 

[Dimitris]

Thank you,
It worked fine.

Private Sub F2_AfterUpdate()
If Me.F2 = "OK" Then Me.F3 = Me.F1
End Sub