pass value from subform to form

[sjohns35]

I have an ordering database. My main form lists information about each specific item that is ordered (when requested, when ordered, by whom, how many, etc.). I have a couple of subforms that will list the other items in an order with the same PO or Requisition number.

What I'd like to be able to do is double-click on an item from my subform and have my main form switch to that item.

For example, If I have two items under PO 00001, I'd like to be able to have the main form open on Item1, then double click on Item2 in the PO subform and have the main form move to the information about Item2.

Can anyone give me some direction? Each item that is ordered has a unique identifier, but I can't figure out how to pass that value from the subform to the main form.

 

[CEH]

Your set up doesn't seem right... Your main form is an order, your subform is the detail of that order... So you should have a one to many relationship there... If there is some detail on items in the subform you wish to display on a double click I would open another form...or another subform. If your Order changed on double click then your detail should change.