Update MAIN from from SELECTION in SubForm

[Guest]

Here is the scenario - using Access 2003.

tblMain is a parts master
tblBOM is component parts of the parent (Main)

I have a form based on tblMain with unbound combo box. User types PN into
combo and After_Update finds the PN and populates the sub_form (tblBOM)
datasheet view.

What I want to be able to do is dbl-click line item in subform and have the
combo box search for the components to that PN, then refresh the subform
accordingly.

Say I have PN 123 which is made up of component parts a, b, & c.
I want to select c and see that it is made up of component parts x, y, & 4.
I don’t want to type “c†into the combo box, rather I want to dbl-click it
in the subform and have it happen automatically.

I KNOW this can be done, but I’m not sure how to do it.

Hopefully, I was clear in my explanation.

 

[Guest]

If I understand this correctly, you have a main form, from which you select
the PN number, which populates a continuous subform. Then you want to double
click one item in the subform and have display that data? You are only
talking about a main and one subform. It seems to me you need 2 subforms to
do this?

It is not quite clear what you want to do, If your subform shows parts a, b
& c on a continuous form, to show the detail of one of those items, it needs
to be shown on another form, can't be on the same form.

 

[Guest]

Anne,
Thanks for your reply/question.
The subform is NOT a continuous form, but rather a datasheet view of all of
the COMPONENT parts that make up the PARENT PN chosen in the combo box in the
main form header. Aside from the combo box in the header, the SUBFORM is the
only data on the form.

When you select a PARENT PN from the combo - it shows all of the COMPONENT
PN's that make up the PARENT. There are COMPONENTs that are also considered a
PARENT since they too might be made up of many other COMPONENT parts.
The diff is that the PARENT PN is UNIQUE - where the components have a KEY
field and are tied to the PARENT.

Again, I'm sure I should be able to pass the COMPONENT PN into the COMBO box
as a PARENT PN to look up the children/components parts.

Eva H. Linich
Business Applications