How do you transfer fields

Headach

New member
Local time
Today, 07:18
Joined
Feb 1, 2001
Messages
7
Hey guys, need a little help here.


I?ve been stuck on this problem for a while.
I would like to find out how to transfer data that is on one form to another form.


What im looking to do is transfer about (5) fields from form A to form B. Once trnasferd the user would have to complete the rest of form B.
When completed user will then hit save form B. The info. will be saved on a different table which will include the same (5) transferd fields.

Right now i'm having problems transferring the fields and then saving the fields i transfered.

I hope you can help me out. thank you.


If you can send the example code via email to me I would be thankful.
Email = zismile@hotmail.com
 
On your second Form set the default value of the required fields pointing at the associated fields on the first Form.

e.g. =Forms![Form1]![myFirstField]
=Forms![Form1]![mySecondField]
 
Hi Keith ....

I logged on to respond to an email from zismile (received Friday?), regarding his/her query above.

I was intrigued to find your response ala the default property setting ... am I right that that solution will only work for new data entry form?

Versus a lengthy macro or procedure using the setvalue action for passing the values from form1 to form2 etc. ???

Am I wrong in assuming the default value solution you mentioned will only work on a new record entry?

TGH
 

Users who are viewing this thread

Back
Top Bottom