Taking record from other table an copy it in a datasheet form.

[eko99312]

Almost the same like my previous question.
To make a Purchase Order (PO) normally user should give us Requisition. The requisition already input to a table (Requisition table) through a form.

The PO form contain
1. PO number
2. PO date
3. User
4. Item
5. Quantity
6. Price
7. Completion date
8. PIC

To avoid entering the same data in Purchase form (for number 4 and 5), I'm intend to copy that requisition item (in Requisition form) to a PO form. Is that possible?
Regards

[NeoPa]

The answer would be the same, or very similar. See Copy or duplicate a record for repeated job or action in a form.