>>>Sometimes when I ask for TextBox.Value, I get a different result than the underlying field, MyTable.MyField. This happens when the user just changed the value.
>>>
>>>If I postpone the check, for instance with a Timer, I get consistent results. Is there a better way to do this?
>>>
>>>TIA, Hilmar.
>>
>>Hilmar,
>>
>>The controlsource is updated after the Valid event fires. Prior to that the value property and controlsource may have different values.
>
>Thanks.
>
>It makes sense, too, if you put it this way.
>
>Now, is there a way to force this synchronization? Perhaps I should invoke MyTextBox.Valid()? Or SomeOtherTextBox.SetFocus()?
>
>Hilmar.
Hilmar,
I achieve this in my Save class with
If Type("thisform.ActiveControl") = "O"
thisform.ActiveControl.SetFocus()
EndIf
HTH
Caroline