Calculated field not update and visualize the correct value (1 Viewer)

amorosik

Member
Local time
Today, 18:25
Joined
Apr 18, 2020
Messages
502
I have one form, continuous form, which I use to display data from an Articles table
The last two columns of each row are calculated fiel, for example

=DLookUp("PRZ";"PREZZI";"cod_art='" & [CODICE_INTERNO] & "' and cod_dep=1 and cod_val=1 and cod_lis=" & cmbCodiceListino1.Value)

The problem I'm writing about is that the calculated fields in the form body are not always automatically updated, as I would expect it to do
And especially on three workstations that use the exact same program, only one of these presents the problem described above
If i press F9 on keyboard (there are not event for F9 key) then field are visualized

What could cause the failure to automatically update and visualize the calculated fields?


1689175486769.png


1689175534408.png
 
it is probably a timing issue. Try adding a
Me.Recalc
in your on load event. If that does not work try it also in the on current event.
the recalc should cause all calculated controls to recalc
 

Users who are viewing this thread

Back
Top Bottom