copy a field in a form

[CAM]

Hello,

I am using Access 2002 in my form I have a field call "Status" another field
call "Position" now I have another field call "Status Recommend" and another
field called "Position Recommend" what I want to do is have a command button
that will copy the data from "Status" to "Status Recommend" and "Position"
to "Position Recommend" how do I do that? I don't know the code. Any tips
will be appreciated. Thank you in advance.

Cheers.

 

[Piet Linden]

Hello,

I am using Access 2002 in my form I have a field call "Status" another field
call "Position" now I have another field call "Status Recommend" and another
field called "Position Recommend" what I want to do is have a command button
that will copy the data from "Status" to "Status Recommend" and "Position"
to "Position Recommend"  how do I do that?  I don't know the code.  Any tips
will be appreciated.  Thank you in advance.

Cheers.

Me.Controls("Status Recommend")=Me.Controls("Position Recommend")

 

[John W. Vinson]

Hello,

I am using Access 2002 in my form I have a field call "Status" another field
call "Position" now I have another field call "Status Recommend" and another
field called "Position Recommend" what I want to do is have a command button
that will copy the data from "Status" to "Status Recommend" and "Position"
to "Position Recommend" how do I do that? I don't know the code. Any tips
will be appreciated. Thank you in advance.

Cheers.

The code might look something like:

Private Sub cmdAccept_Click()
Me![Status] = Me![Status Recommend]
Me![Position] = Me![Position Recommend]
End Sub

You could also do this in a Macro using Setvalue, but I don't use macros much.