Unbound fiels is not updated properly

[Niebotel]

On a form I have two date fields (with pull down menu for selecting the date); after leaving the field a calculation takes place.

On another normal field I have the same trigger and calculation.

On another unbound field I have the value calculated depending from this calculation and the value of two other fiels on this form; so far no problem but...

If I leave the Date field by using the enter key or tab key the depending field is empty until I click somewhere on the form.
If I do the same from the normal field the depending field is updated immediatly.

The form is quit complicated so I do not want to change a lot;
So a simple workaround to solve will do: is there a command which simulates clicking on the screen. Me.refresh did not help

 

[dhookom]

Are you using code to calculate values in other controls or just expressions in control sources.

Please remember a "field" is a column in a table or query. Controls are on forms and reports and can be bound to a field or expression.

Duane
Hook'D on Access
MS Access MVP

 

[Niebotel]

Yes I understand the difference between Controls and fields; sometimes have problems because I translate from Dutch into English.

I now use expressings in control sources.
Can I also do it in code if the controls are unbound?

 

[Niebotel]

I changed it into code and the problem is solved; thanks for the hint!