I need some help in subform references in formulas, ie, I have
Main form: frmMain
subform sfrmSub1
sfrmSub1 fields: cost1, cost2, iCnt
sfrmSub1 will have more than 1 record
For instance, how do I do calculations such as cost1 * iCnt, cos2 * iCnt etc. Also, how do I differentiate between sfrmSub1 record 1, 2 etc? Sorry if my terminology is incorrect, I do not do a lot of Access programming!
Thanks
Main form: frmMain
subform sfrmSub1
sfrmSub1 fields: cost1, cost2, iCnt
sfrmSub1 will have more than 1 record
For instance, how do I do calculations such as cost1 * iCnt, cos2 * iCnt etc. Also, how do I differentiate between sfrmSub1 record 1, 2 etc? Sorry if my terminology is incorrect, I do not do a lot of Access programming!
Thanks