i have a sub form for Dr's visits, and a total field on the main form. every time you fill out the Dr sub i need a 1 to populate the total field on the main, however theres going to be more than one Dr's visit so is it possible to let the subform cycle but keep a running total on the main total field (i.e 5 Dr's visits). The reason i have the sub form is 1. for space saving, and 2. theres another Dr subform for pstchiatrics that i want to keep seperate.
Also how do i get the total of a sub form on to the main total field?
box 1 = m1 total box = med_tot
med_tot = m1
Please help or point me in the right direction