I have an unbound text box in a Form footer that calculates work days based on two dates in a form. The work day value is calculated with code (per faq 181-261, which works great I might add). I have it working properly using a command button.
However, I want the value to calculate automatically for whatever record is selected with the mouse or nav buttons (as if it were simply an [EndDate]-[StartDate] calculation in a text box).
To my knowledge, there isn't an "On Change Record" event property for Forms. How can I get the control to calculate automatically?
Better yet, is there a way to run this same code calculation within the query for all the records?
I'd be grateful for any suggestions. Thanks.
However, I want the value to calculate automatically for whatever record is selected with the mouse or nav buttons (as if it were simply an [EndDate]-[StartDate] calculation in a text box).
To my knowledge, there isn't an "On Change Record" event property for Forms. How can I get the control to calculate automatically?
Better yet, is there a way to run this same code calculation within the query for all the records?
I'd be grateful for any suggestions. Thanks.