Using the Clipboard in a Macro in a form

[mchadwick]

I used to be able to do this in previous versions of office (DoMenuItem \ Copy or Paste). This is what I'm trying to do: Create a button with an event behind it that will when I press the button go to a control (field) in what ever record I am currently in. Copy the text in the control\field go to another control in that same record and paste the information into that field or control. It used to be quite simple and worked really well for what I am trying to do, I just cant find anything in the macro menus. Any help would be appreciatted

[Robeen]

Would you like to consider doing it using VBA Code?
It's really pretty easy.
I ran this little test up in under a minute:
My form has a Text1 and a Text2 and a Command4.
In the Code for the On Click Event for the Command Button

Select the command button
Property Sheet -> Event -> On Click -> click the [...] to the right -> Select 'Code Builder'.
Put this between the two lines already in there [substitute your Text Box Names where I have Text2 & Text1:

Me.Text2 = Me.Text1

In my case - when I type something into Text1, and click the command button - the text from Text1 is pasted into Text2.

Hope this helps.
I find using the Macro Actions a little limiting and using VBA Code a lot more versatile.

[mchadwick]

yeah I think I can do that. so, is me. the form name and text1 the control or field name?

[mchadwick]

I did get that to work and thank you for that. I would also like to be able to to a different form for the same record (attached to each other by linked master fields andn link child fields). How do I do that as well

[mchadwick]

I've attached a small DB as an example of what I would like to ulimately do. Testing1 is the main form. from there I would like to hit command1 button and take the data from the field "copyfromfield" to the table2field in the form or table table2. But I want the data to go to the correct record based on the linked master fields and child fields.

[mchadwick]

here is the database

Database5.accdb

[Robeen]

yeah I think I can do that. so, is me. the form name and text1 the control or field name?

Yes. That's correct.

[Robeen]

I would also like to be able to to a different form for the same record (attached to each other by linked master fields andn link child fields). How do I do that as well

Here's a site that gives you some quick exampleas of how to do this.
http://www.baldyweb.com/wherecondition.htm

Let me know if that doesn't help.

[mchadwick]

this is actually useful, I knew you could do that but I didnt know how. What I need is different though.