Copy Data from One Subform to another Subform.

[Kaloyanides]

I'm sure this been asked/answered many times before but I can't seem to find the answer.

I have an order Entry Screen. The Invoice Number is not issued or finalized until the user clicks "Issue Invoice" after all of the items have been entered.

On the Order Entry Screen I have two subforms. One is for the actual order (items) and the other shows all of the items the customer has purchased in the past. It would be great if the user could click the button next to each previously ordered item and have that item auto populate into the order entry subform. Add the item and then setfocus to the items QTY field.

frmSalesOrdersSUBitems - Order
qrySalesInvoiceItems
frmSalesOrdersSUBTemplate - Previously Purchased Items
qryCustomerTemplates

If anyone can help, I'd be very grateful!

Thanks!

[Bob Fitz]

Can you post a copy of the db

[Kaloyanides]

I'm not sure how I would do that being a rookie and all...

I have a main form that contains two subforms. One on top of each other.

The top subform is for the order entry.

The bottom subform displays all of the items the customer has ordered in the past.

I want to be able to click on an item in the bottom subform and have it automatically inserted into the subform above (the actual order entry subform.)

It may be a little tricky because the items in the order entry subform do not have an invoice number assigned to them until after the order is complete and the user clicks "Issue Invoice." At that point, the invoice number is generated and assigned to the order and all of the items in the order entry subform (top.)

Hope this all makes sense.

This is all I have so far:
Me!frmSalesOrders.Form!frmSalesOrdersSUBitems.ITEM NUM = Me!frmSalesOrders.Form!frmSalesOrdersSUBTemplate.I TEMNUM
Me!frmSalesOrders.Form!frmSalesOrdersSUBitems.Invo iceItemQuantity.SetFocus

This works except when you do more than one item, it always inserts in the same spot (top row of datasheet order entry subform.) It needs to go to the first available line or a new record for each item after the first.

Thanks!

[ssanfu]

I'm not sure how I would do that being a rookie and all...

Do a "Compact & Repair"
Compress the dB (create a zip file)
In a reply, click on the "Go Advanced" button
Scroll down until you see a button "Manage Attachments". Click on the button.
Follow the prompts.
(max Zip file size is 2 MB)

[Micron]

A posted db copy might be best (and eventually, the only way to help).
But if you know how to create the new order, maybe all you need is a double-click even on the subform record and use an append query to write the required values from the history table to the new order table. You might want to explore a double click event on the new order record to remove an item should the user not want a record that was just copied. Either way would likely require a requery of the order subform. As for where it goes in the order, you'd sequence order subform records on whatever field makes sense if necessary, but I don't see why the order of the items wouldn't just follow the sequence as they were entered.