How to use calculated field in next field's Source

[upsman]

I am using a function to calculate the number of days in a quarter. I have the Control Source for field "A" set to
=CalcQtr1Days([AdminDate]). I am calling CalcQtr1Days and passing the AdminDate. It calculates the number of days I'm looking for and returns that number in my field. Then, I want to use that number, along with DaysAbsent, to calculate DaysPresent. So, in field "B" Control Source, I have =CalcQtr1Days - DaysAbsent.
This gives me #Name? in field "B". I've also tried =DaysPresent = CalcQtr1Days - DaysAbsent but doesn't work either. What is the syntax for using the value calculated in field "A" in my calculation for field "B"?

Thanks,
Rod

 

[RuralGuy]

You need to reference the name of the control not the name of your functions. Hopefully you have *not* named your controls the same name as your functions. I put a prefix on my control names that identifies the type of control: txt for TextBox, cbo for ComboBox, etc.