I thought it was simple(subformStuff) but Maybe Im just stupid.

[KaiProton]

Ive got a form, that has inputs to a table, and it also has 2 subforms that link to another table, the subforms are different forms but they link to the same table, this is bacause I need to be able to enter two different items off the table that may be different items, the reason Ive used subforms is because there is the need to have the part number for the item, as well as the weight, this will be a growing list as the Dbase expands.
now I have the two subforms with a combobox for part number, and the weight field looks up because of the combo,

back on the main form I need a entry that adds up the 2 weight fields, and enters them on the main table that the main form writes data to, can someone help?

Ive been heatbutting my monitor for a week or two now, and my limited know how on Access is beginning to show

Thanks.

 

[___]

back on the main form I need a entry that adds up the 2 weight fields, and enters them on the main table that the main form writes data to

Why do you need to store calculated values in the table? The calculations can be done in a query, on a form or in a report.

HTH

 

[Mile-O]

Why are you wanting to store calculated values?

I still don't understand why you have two subforms bound to the same table. Actually, I wouldn't even understand why you had any form bound to any table. That's what queries are for.

 

[KaiProton]

The Reason there is 2 sub forms Bound to the same table, is because I need to have the options to have the same item twice, but also maybe different items in there place,

they are caps on the end of hose,
so there may be Cap1 and on the other end Cap2
but another part may use cap1 and on the other end Cap3

and all these caps need to show there weight value,
so I then need to add up the total cap weight and then add it to the total weight of the parts, that will be calculated on the form as the user inputs the weights for the components that are uses, basically the caps are packing and Ive been asked to show the weights of packing, and the caps is the only place i cant find it,

if this doesnt help, I could post my Dbase somewhere if someone can look at it and help from that way,

the other problem being that each one of these may or may not have the caps and components, it might be easier for me to divide them into the part classifications and make different tables and forms for each type of part.