RE: Expression in a form

Thank you all

I moved the expression to the Queery and it works fine.

Quinto

Klatuu wrote:
>The value in Field21 will update whenever [EndMiles] or [StartMiles] is 
>changed by a user entering the values on the form; however, if either of
the 
>values is changed programmatically, Field21 will not change.  You can
cause 
>it to change by using the Recalc method.  Recalc does not appy to a
control, 
>but to the form, so where ever you have code that modifies either of the 
>values, follow the calculation with
>Me.Recalc
>> I have a simple expression in a form 
>> Field21: =[EndMiles]-[StartMiles]
>[quoted text clipped - 6 lines]
>> 
>> Quinto

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200808/1