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

[amorosik]

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?

 

[MajP]

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

Access Requery Or Not To Requery - That Is The Question

The following four methods can be found in Microsoft Access and have different uses: Access Requery Access Refresh Access Repaint Access Recalc They can be split into two parts where the first two points handles records (the data) and the latter two the objects and their components (no data)...

accessdatabasetutorial.com