Copy-Paste

[BorisGomel]

Hello ,



I am just wondering if can I copy paste contest one filed (text Box calleD "JSTCOURT") onto another text box called "NAMES". I have a form named "court" and subfrom on it called "debtors". i WOULD LIKE to select contest off text box "JSTCOURT" and paste it to text box "NAMES" on subfrom once I put cursor on text box NAMES and click cummond button. I put code onto commund button, but ot doesn't work .The reason I need that that we process thousand rows of data from big bank banks saush as cap one, city and I need filed JSTCOURT to be populated before runnning macro in Access, otherwise the record will be gone. So what I created the form amd subform, but there is a lot of typing , instead I would like to copy-paste.
"NAMES = JSTCOURT".

Thnak you for your help,

The best Regards,

BorisGomel

[June7]

Try using:

RunCommand acCmdCopy

RunCommand acCmdPaste

[BorisGomel]

Due to respect June7.
How can I do that.Do I need to type this into commund box clik event or how can I use it ?
Thank you very much for replay.
The best Reagrds,

BorisGomel

[June7]

Yes, it would have to go in an event.

I really don't know how it actually works, never used it. Might require some code to first set focus to the control to copy from then set focus to the control to paste into.

That code essentially does what Ctrl+C and Ctrl+V would accomplish.

I might have been running down wrong path directed by your copy/paste question. Maybe in button Click simply:
Me.subformcontainername![Names] = Me!JSTCOURT

[BorisGomel]

tHNAK YOU VERY MUCH JUNE7!!!
You really save me a lot of time on my job.
The Best Reagrds,
BorisGomel