Moving data from one form to another 1

[liwan]

Dear Ppl,
I am currently using Access 97.I want to transfer data(a few attributes) from Form A to Form B which have the same attribute name. I wanted it to be automated, when I finish inserting details on Form A, I'll have a command button to goto Form B ,thus,I want Form B with the same field as Form A automatically to be filled.
Please help!!
Regards,
liwan

 

[Rolliee]

liwan,

are they really different forms or the same form with different data. In other words, do you close one form and open another?

Rollie E

 

[liwan]

Dear Rolliee,

SO glad somebody answered!! Is a different form. E.g: Form A have 10 fields,and 4 of them are the same with Form B's fields. When I finish entering data in FormA , I'll click on a command button in FormA to open Form B.I would like the 4 fields to be filled when it is open.
Thanks in advance!!

Regards,
liwan

 

[dzepeda]

See thread702-597199

 

[liwan]

Dear dzepeda,

I tried using the code butthe compile error : Method or data not found in Form B. Whereas Form A say variable not defined.I am wondering what do I defined it AS () I tried textbox and fields but it say for intrinsic use only.Btw, I am using Access97.Please advise, thanks.

Regards,
Amanda

 

[Rolliee]

liwan,


To open the new form there is a command in the underlying code that says this:

DoCmd.openform "frmName2"


In front of that code put

DIM var1 ,var2,var3,var4 as variant

var1 = me.somefield1
var2 = me.somefiels2
var3 =.....
var4 = .....

After that DoCmd code put:

me.somefield5 = var1
me.somefield6 = var2
ditto
ditto

You must of course use your form and variable names.

Rollie E

 

[DawsonUK]

I used a similar piece of code for transferring details of people from one form to another.... here goes

'First open the form
DoCmd.OpenForm "form2"

'Now the form is opened, put in variables!
Forms![form2]![value1] = Forms[form1]![value1]
Forms![form2]![value2] = Forms[form1]![value2]
Forms![form2]![value3] = Forms[form1]![value3]
Forms![form2]![value4] = Forms[form1]![value4]
Forms![form2]![value5] = Forms[form1]![value5]

Should work fine

David

 

[liwan]

Hey guys!!

It works perfectly the way I wanted it thankS you so much. Thank to you David & Rollie!! I have another thread which is unanswered at all. Any idea on that! How do I putmy selected contacts from the form to a word document?

Regards,
liwan