Copying a field

[Guest]

I'd like to copy a ceratin field on the current form
I can use the command 'DoCmd.gotocontrol' to move the focus on the field
that I'd like to copy ,but how can i copy it ????????????

 

[Douglas J. Steele]

You may need to supply more information. Copy the value where? To another
field on the same form? To another field on a different form? To the
clipboard?

If Control1 and Control2 are on the same form, you can use:

Me!Control2 = Me!Control1

If they're on different forms, you can use the following (provide Form2 is
already open):

Forms!Form2!Control2 = Me!Control1

 

[Guest]

I'd like to copy it to the clipboard.(that's to say that I'd like to copy it
to paste it in a "word document" for example)

 

[Douglas J. Steele]

Set focus on the field, then use the RunCommand method:

Me.Control1.SetFocus
DoCmd.RunCommand acCmdCopy