populating data from one form to another.

[cololac via AccessMonster.com]

Evening,

I'm trying to create a form that you key in data on. Then later on another
user can view this form and data and decide to create a new form with the
data in the old form. I'd like to be able to add a checkbox that when you
select it, that record rolls over into the new form. Here is the
functionality I'm trying to create.

I have a Requistion form. The main form is per requisition. The requistion
then has a subform with contains the many lines of products that the
requisitioner would like to order.

After the Requisition is keyed in, I would like the purchasing agent to
review the requistion and select which items can be ordered together from the
same vendor. Using the checkbox to indicate which records to select, I would
like to have a command button that the purchaser selects and then a purchase
order is created. However, the purchase order is made up of a header and
subform as well. The header would autonumber upon creation and most of the
data would be entered at data entry. However, the lines of product from the
requisition would need to be added to the purchase order subform.

First, does this make sense and if yes, how do I accomplish this? I would
appreciate any help you can give me. Thanks!!!