Search results

i have two combo box in 2 different forms. the first combo (material) in the main form and the second combo(submaterial) in the nested subform. i need to show the list of the second combo"submaterial" box based on the selection of the first one"material" the rowsource of the "material" combobox...

yeah i read it, the criteria must set that the sum should be performed grouped by ID.that is sum the qties that have same id together.but it s not applying here.dont know why

thank you man for ur time. in fact the main and subform are linked together and everything is fine concerning this matter.but when it comes to the macro, it s calculating the sum and showing it for all IDs. lets say ID=1, qty=3 ID=2, qty=2 ID=1, qty=2...

no the records are in the one subform. i used the Dsum function its working but i cannot save the value in the main form table although im referencing to this field in the table. not a problem i can save it in the subfrom table. one more problem the form subform are linked with a one to many...

i have a form that contains two nested subforms relationships already set and working fine size1, size 2, qty and total qty are fields from the nested subform. qty is calculated from size1*size2 total qty will be the sum of "qty". i need to store these calculated fields qty and total qty in the...

wat expression can i use with a set value macro to sum records from a table when i use the Sum in the expression field i get errors saying that it cant find the form refering to its record value.

the text box on subform referencing to the subtotal on the nested subform shows # error if nested subform not expanded. once expanded it updates and show the value on the subform. it only updates if u expand the nested subform one at a time. if u expand two nested subform consecutively, the...

hello everyone, I am facing a problem with displaing a calculated value from a nested subform(B) on the subform(A) which is a subform of a main form (X). i m calculating the Total in the nested subform(B) and i want to show the total on the subform (A). when i open the subform(A), the value...

hello everyone, I am facing a problem with displaing a calculated value from a nested subform(B) on the subform(A) which is the main form (X). i m calculating the Total in the nested subform(B) and i want to show the total on the subform (A). when i open the subform(A), the value is always...