how to copy data from f1 to f2?

[ghost]

Greeting,

I have form 1 and form2, I would like to copy the data from f1 to f2 by
clicking on command button in f1 and go to f2 and click on command button to
past data, how to make that???

 

[Daniel Pineault]

It depends on which form will have the button

it will be something like

Me.Form2ControlName = Forms![Form1].Form![Form1ControlName].Value

in the above example I have assumed that form2 has the button which copies
data from form1.

 

[Daniel Pineault]

FYI, if you want to capture data changes that have not been commited yet you
should switch the ....Value to ....Text
--
Daniel Pineault

It depends on which form will have the button

it will be something like

Me.Form2ControlName = Forms![Form1].Form![Form1ControlName].Value

in the above example I have assumed that form2 has the button which copies
data from form1.
--
Hope this helps,

Daniel Pineault
If this post was helpful, please rate it by using the vote buttons.

Greeting,

I have form 1 and form2, I would like to copy the data from f1 to f2 by
clicking on command button in f1 and go to f2 and click on command button to
past data, how to make that???

 

[John W. Vinson]

Greeting,

I have form 1 and form2, I would like to copy the data from f1 to f2 by
clicking on command button in f1 and go to f2 and click on command button to
past data, how to make that???

STOP.

Neither f1 nor f2 contains any data. A Form IS JUST A WINDOW, a tool to let
you edit data in tables.

What are the Recordsources of the two forms? If they are the same table, then
you don't need to copy anything - at the most you need to requery one of the
forms. If they're not the same table, then you may be trying to store data
redundantly, which is A Very Bad Idea. It's very rare indeed to actually need
to copy a value from one form to another form (except in the case of a Form
and Subform, in which case the automatic Master/Child Link Fields do it
without any code at all).

What are these forms, and what are you trying to accomplish?