Cordeiro82
MIS
Hello All...
I am designing an order database in Access 2003 and I am currently working on allowing the user to copy a list of products from an old order to a new order.
This allows the user to pre-populate the products subform of a new order based on a similar older order.
The order table is as follows
Order_ID
Order_Date
Delivery_Date
etc....
The Order Details Table is as follows -
Order_ID
Product_Number
Quantity
List_Price
I have a main form called customer that holds a order subform allowing the user the view all the orders for a customer. Each order in this subform has a duplicate button.
When I click the 'duplicate' button for a particular order in this subform I want the order form to pop up with a new order_ID but pre-populate the products subform of an order with the older order details.
I know how to get it all working except the last bit that has me prepopulate the product subform based on products from a previous order(the order does not necessarily have to be for the same customer). Would somebody please help??
I am designing an order database in Access 2003 and I am currently working on allowing the user to copy a list of products from an old order to a new order.
This allows the user to pre-populate the products subform of a new order based on a similar older order.
The order table is as follows
Order_ID
Order_Date
Delivery_Date
etc....
The Order Details Table is as follows -
Order_ID
Product_Number
Quantity
List_Price
I have a main form called customer that holds a order subform allowing the user the view all the orders for a customer. Each order in this subform has a duplicate button.
When I click the 'duplicate' button for a particular order in this subform I want the order form to pop up with a new order_ID but pre-populate the products subform of an order with the older order details.
I know how to get it all working except the last bit that has me prepopulate the product subform based on products from a previous order(the order does not necessarily have to be for the same customer). Would somebody please help??
