Data of one field to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dimitris - 12 May 2008 10:46 GMT

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

Reply to this Message

Brendan Reynolds - 12 May 2008 11:02 GMT

> Hello.
> In a form I have three fields F1 and F2 and F3. What I need is that
[quoted text clipped - 5 lines]
> Thank you
> Jimmy

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

Signature

Brendan Reynolds

Reply to this Message

Dimitris - 12 May 2008 12:27 GMT

Thank you,
It worked fine.

> > Hello.
> > In a form I have three fields F1 and F2 and F3. What I need is that
[quoted text clipped - 9 lines]
> If Me.F2 = "OK" Then Me.F3 = Me.F1
> End Sub

Reply to this Message