Check box to copy data

[tjr222]

Is it possible to transfer data from one or more cells of a record in one form to another existing form, simply by checking a yes or no toggle box that relates to the record that will be transfered or copied?

For Example:
I have to forms Upcoming Jobs and Current Jobs. When the upcoming job becomes a current job I would like to just fill in the check box and have it transfer three cells of a record from Upcoming to Current jobs.

If anyone has any ideas how to do this please let me know. Thank you.

 

[fernin8r]

i would, in the AfterUpdate property of the check box, put:

If (Me!Check123 = True) Then
Me!Field1 = Forms![Current Jobs]![Field1]
Me!Field2 = Forms![Current Jobs]![Field2]
Me!Field3 = Forms![Current Jobs]![Field3]
End If

 

[fernin8r]

that will only work when both forms are open.

 

[fernin8r]

i'm sorry... i think i wrote the equation backwards

If (Me!Check123 = True) Then
Forms![Current Jobs]![Field1] =Me!Field1
Forms![Current Jobs]![Field2] = Me!Field2
Forms![Current Jobs]![Field3] = Me!Field3
End If

 

[tjr222]

Thanks that worked well. The only problem I have now is that when I open my "Current Jobs" it is automatically at the most recent job and not in a "new entry." It therefore overwrites whatever is the most current job which is where the curser is.

So do you have any ideas of how to add to the code to move the curser to a new entry. Also would it be possible to add in the code to automatically open Current Jobs, that way when I click the check box it will 1st open, then move to the new entry, and then copy the info (which it already does). Well if you have any more ideas please let me know. Thanks again.