Modification of AceMan's Answer to thread702-1459928 1

[kristi1023]

thread702-1459928

Instead of copying and pasting the contents of a textbox to the one below, I'd like to copy and paste the contents to the one to the right. Is that possible? The name of the textbox I'd be copying from is M14 to M15. WOuld it make a difference that these textboxes are on a continuous subform?

Thanks,
Kristi

 

[PHV]

Why not simply this ?
Me!M15 = Me!M14

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kristi1023]

I modified the code to find something that works, it's probably not the best solution:

Dim Nam As String, hldVal

Nam = Screen.ActiveControl.Name

hldVal = Me(Nam)
Me.M15 = hldVal

So, my next question, is it possible to copy M14 to M15 for all of the records in the sub-form on the click of a button? For instance:
Record 1 - M14=100
Record 2 - M14=200
Record 3 - M14=200
ETC.
Then after the button is pressed:
Record 1 - M15=100
Record 2 - M15=200
Record 3 - M15=300
ETC.

Thanks a lot!

 

[PHV]

I'd use an UPDATE query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kristi1023]

Thanks, PHV. I was clearly overcomplicating this. I am going to use the double click method with Me.M15=Me.14 for the user to update only particular records and an update query if the user wants to update all records.

Thanks again!