Hi all!
I would like to copy data from one form to a subform on a separate form.
The user wants to place an order, so he clicks a button that opens a form with datasheet to search for something. A checkbox is on the record of each item, so he can select multiple items. Then, click button to view selected items, then "copy" most of the record's data to another form.
The data is "copied" from one set of tables to a new record on another table. The tables being searched on comprise an order history table, compiled from years of previous orders. (Items---VendorItemJoin---Vendors) The join table provides multiple part numbers and multiple vendors.
The tables that store the more current data are Orders and Orders Details. I can’t put the older data into the new tables, because there is no Order Number associated with the old data. (OrderID ---- OrderIDFK)
I have been able to copy the data into the table of the subform I wish to populate (using recordsets), but it does not appear in the subform until it is re-opened. Which makes sense. (I can also get the new OrderID from the Orders form after it opens, and use that ID in the Details table as I copy this data over.)
So, when the main form opens, a new record is being created in the Orders table and at least one new record in the Details table. New data can be entered directly into the Details subform, but I would like to allow the user to add data from the “outsider tables” as well.
Thanks,
Mike
I would like to copy data from one form to a subform on a separate form.
The user wants to place an order, so he clicks a button that opens a form with datasheet to search for something. A checkbox is on the record of each item, so he can select multiple items. Then, click button to view selected items, then "copy" most of the record's data to another form.
The data is "copied" from one set of tables to a new record on another table. The tables being searched on comprise an order history table, compiled from years of previous orders. (Items---VendorItemJoin---Vendors) The join table provides multiple part numbers and multiple vendors.
The tables that store the more current data are Orders and Orders Details. I can’t put the older data into the new tables, because there is no Order Number associated with the old data. (OrderID ---- OrderIDFK)
I have been able to copy the data into the table of the subform I wish to populate (using recordsets), but it does not appear in the subform until it is re-opened. Which makes sense. (I can also get the new OrderID from the Orders form after it opens, and use that ID in the Details table as I copy this data over.)
So, when the main form opens, a new record is being created in the Orders table and at least one new record in the Details table. New data can be entered directly into the Details subform, but I would like to allow the user to add data from the “outsider tables” as well.
Thanks,
Mike
