Now have it working.
I created a query that shows the record from the previous year
VBA opens the form based on the query.
I then use dblLastYearFTEPaidOut = Forms!frmCalculateKioskPercentages.dblEffectivePai dFTE.Value
Close the form.
Then calculate the percentage difference. dblPercentageFTEPaidOut = (dblEffectivePaidFTE - dblLastYearFTEPaidOut) / dblEffectivePaidFTE
Last edited by wobmat; July 23rd, 2009 at 05:30 AM.
Reason: Changed method of getting value