D
Donna
Hello,
I am working on a db for a 5 yr budget. (using Access 2000) I have an input
form that the user will supply an amount by month (Jan-Dec) the first year,
quarterly for the second year, and an annual total for the 3rd-5th yrs. My
attention is on the monthly part. Included in the main table, there is a
Total field for the 1st and 2nd years. On the input form, as the user enters
data into the monthly fields, I would like to see the Totals field update
after the user enters the data. I have placed a subform based on a totals
query, linked to the main form, that will show a total for that line item. I
would like to see it update also.
I placed an unbound text box (named curCalculate) in the main form (not
visible) and have tried to place the code in here to add all 12 months and
then put the sum in the Totals field. I get a total, but its a total of all
the records for Jan, Feb, etc.
My thoughts are to use the After Update or Lost Focus events of the Jan-Dec
text boxes to use the amount in the curCalculate. I don't know how to write
the code to focus on the individual record. I have a few books and the HELP,
but it hasn't been of much use. Would someone help me with this please?
Thanks so much!
Donna
I am working on a db for a 5 yr budget. (using Access 2000) I have an input
form that the user will supply an amount by month (Jan-Dec) the first year,
quarterly for the second year, and an annual total for the 3rd-5th yrs. My
attention is on the monthly part. Included in the main table, there is a
Total field for the 1st and 2nd years. On the input form, as the user enters
data into the monthly fields, I would like to see the Totals field update
after the user enters the data. I have placed a subform based on a totals
query, linked to the main form, that will show a total for that line item. I
would like to see it update also.
I placed an unbound text box (named curCalculate) in the main form (not
visible) and have tried to place the code in here to add all 12 months and
then put the sum in the Totals field. I get a total, but its a total of all
the records for Jan, Feb, etc.
My thoughts are to use the After Update or Lost Focus events of the Jan-Dec
text boxes to use the amount in the curCalculate. I don't know how to write
the code to focus on the individual record. I have a few books and the HELP,
but it hasn't been of much use. Would someone help me with this please?
Thanks so much!
Donna