G
Guest
I have a form that has the following: 5 boxes for fiscal years and 5 boxes
for budgets for the idicated fiscal year. i want the form to let me choose
the first year from a drop down box (got this part) then have the next five
years be auto filled (got this by doing =year+1, =year+2 etc in countrol
source). below that i want the budgets for each year to be shown. i linked
the tables and got the budget for year 1 to show up but if i do =budget+1 in
the control source 1 is added to the first year budget. I guess my question
is how can i have the year 2,3,4 and 5 budget fields autolook up the data
corresponding to that year?
for budgets for the idicated fiscal year. i want the form to let me choose
the first year from a drop down box (got this part) then have the next five
years be auto filled (got this by doing =year+1, =year+2 etc in countrol
source). below that i want the budgets for each year to be shown. i linked
the tables and got the budget for year 1 to show up but if i do =budget+1 in
the control source 1 is added to the first year budget. I guess my question
is how can i have the year 2,3,4 and 5 budget fields autolook up the data
corresponding to that year?