Place values from a pop-up subform into another subform in a form???
Posted on 2003-11-27
I have a pop-up subform, that pops up over another pop-up subform with a subform inserted. . . . whew thats a mouthful.
I'll try again - I have a pop-up MAIN form (that covers the entire desktop) with a datasheet subform(ITEMS) inserted. On this MAIN form I have a command button that opens up another pop-up form (PRICECHECK) that is 6" by 6" and centered on top of the MAIN form.
On the PRICECHECK form I have a couple combo boxes, a couple text boxes and a command button - the user can select items from the combo boxes which in turn populate the text boxes with values. I want to be able to click the command button and have the values in the 1 of the combo boxes and the text boxes into my ITEMS subform (inserted into my MAIN form).
I originally was going to insert the values into the table that the ITEMS subform is bound to, but the problem is that my ITEMS subform is linked to my MAIN form via a RECORDID (autonumber) field so I need to insert the values into the ITEMS subform so that the RECORDID value will be the same as the RECORDID displayed on my MAIN form.
Holy moly I hope that makes sense - tougher to describe than I thought!