Need to copy Text from one form to another

[Yecats131]

Okay first let me explain what I am trying to accomplish:

I have two forms:

Requisitions
Applicants


I need to copy text over from the requisitions table to the applicants table. This is done based on when the user types the Req# in on the applicant form.

Basically, the requisition is tracked on the Req table. We can have several applicants to 1 requisition. Once the req has been approved and an offer is made some of the original req information can vary (Such as the amount that is being offered to the candidate). I want to keep the original requisition info in the req table and copy over all of the fields that MAY change to the applicant table. At that point the user will review and change any fields that need to be.

I can't seem to get this to work though...

 

[khawar]

You can use a sub form for applicants it will automatically set the requisition # on that form

 

[tarcona]

DoCmd.RunCommand acCmdCopy

I think that is the code....

And then put:

DoCmd.RunCommand acCmdPaste

I hope that helps.