Subform Calculated Column

SteveVS

Registered User.
Local time
Today, 06:32
Joined
Feb 20, 2017
Messages
14
on the subform there is a calculated column that populates a checkbox
I tried to check if the checkbox is checked or not on the before update event but i saw that the calculation is done even before the event is fired

How can i do the comparison before the column is recalculated
 
Is the calculation in the subform recordsource query or just on the form?
 
It is in the query
 
In that case it's result is fixed when the form is populated.
If the underlying data changes you would have to requery the datasource to see the changes - so is something else doing that?

What is the code you have and is there any On_Current event for the form?
 

Users who are viewing this thread

Back
Top Bottom