How can I make a button (on click) to copy text from textbox on one form to textbox on second form

[vazdajic]

Hello!



Before I pop the question, I have following:
Form: LOCATION and on it textbox named LOCATION and a button named COPY
Form: DESTINATION and on it textbox named DESTINATION

Question is:

I want COPY button (on click) to copy text written in textbox named LOCATION to textbox named DESTINATION
How can I make it work (NOTE: at the same time both forms will be open)

[cyanidem]

In On Click event of button:

Forms("DESTINATION").Destination = Me.Location

But... you should really consider changing naming convention to avoid confusion. You have form named DESTINATION and txtbox on it named DESTINATION. Maybe try frmDestination and txtDestination? That would make your design more clear and easier to track potential bugs.

[vazdajic]

It Works!!!!!!!!!!!!!!!

Thanks!!!!!!!!!!!!!!!!

[cyanidem]

Did you even try? There wasn't any code in what you uploaded.
There is now exactly as I advised and it works:

COPY PASTE TEXT.zip

Edit:
Whoa, sneaky ninja edit? At least leave previous version of your post to not confuse readers ;>

[vazdajic]

Aha.. Ok, I will leave previous posts untouched.. Thanks for an advice..

Anyway, after renaming forms and textboxes, It works as an ONCLICK button VBA event:

Private Sub COPY_Click()
Forms("FORM_DESTINATION").TEXT_DESTINATION = Me.TEXT_LOCATION
End Sub

Thank you very much..

One additional question.. It works perfect if both forms are open (I wanted it that way).
Can the button be ordered to first open the second form and then copy/paste the text from first form's textbox?

[cyanidem]

Private Sub COPY_Click()
    DoCmd.OpenForm ""FORM_DESTINATION"
    Forms("FORM_DESTINATION").TEXT_DESTINATION = Me.TEXT_LOCATION
End Sub

[vazdajic]

Thanks, this works ( there was just one extra " )

Thank you )))))))))))

Private Sub COPY_Click()
DoCmd.OpenForm "FORM_DESTINATION"
Forms("FORM_DESTINATION").TEXT_DESTINATION = Me.TEXT_LOCATION
End Sub