Subform Calculated Column (1 Viewer)

S

SteveVS

Registered User.
Local time
Tomorrow, 01:14
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
 
Minty

Minty

AWF VIP
Local time
Today, 23:14
Joined
Jul 26, 2013
Messages
10,371
Is the calculation in the subform recordsource query or just on the form?
 
S

SteveVS

Registered User.
Local time
Tomorrow, 01:14
Joined
Feb 20, 2017
Messages
14
It is in the query
 
Minty

Minty

AWF VIP
Local time
Today, 23:14
Joined
Jul 26, 2013
Messages
10,371
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?
 
You must log in or register to reply here.

Similar threads

R
Solved Importing and calculating the data
Replies
12
Views
500
Robrobby
R
M
Solved Crosstab report - repeating first column for multipage table
Replies
10
Views
607
Martynwheeler
M
C
Cancel unload No currrent record
2
Replies
23
Views
411
ClaraBarton
C
S
Print Subform Table
Replies
3
Views
151
Pat Hartman
P
AOB
Solved Continuous subform displaying boolean results differently to underlying query
Replies
7
Views
252
AOB
AOB

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom