How do you transfer field from one form to another.

[Headach]

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?s on one form to another blank form.


If you can send the example code via email to me I would be thankful.
Email = zismile@hotmail.com


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.
zi


[This message has been edited by Headach (edited 02-01-2001).]

 

[fmccarl]

Let me know if you make any headway with this. I could use it as well.

Thanks

 

[ntp]

Be a bit more specific, do you want all the data from one form to go into another form and if so are these two forms the same(different instances but the same structure)?

I have some ideas but I'll need to know exactly you want.

ntp

 

[TGHockett]

Headach -- I agree with ntp ... if you provide more info on what you are trying to do, you are more likely to find help here.

For example -- why would you want to transfer data to a blank form????

But if you are trying to make sure you pass the current user back to the appropriate record another form is based on, you can use the Where condiditon in the OpenForm action for a macro to accomplish that objective.

Let us know more about what you want to do, what version of Access you are using, and if you are VBA or macro inclined as I am.

TGH

 

[Headach]

What im looking to do is transfer about (5) fields from form A to form B. Once transferd the user would have to complete the rest of form B.
When completed, user will then 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'm using MS access 2000.

I hope you can help me out. thank you.
zi