>I have a textbox for inserting the value of Year. And I have put the value of the textbox through
>
>thisform.txtYear.value = year(date())
>
>in the Form Init. However, if I don't get focus to the textbox (even with the "1999" value display) , my Year field won't get updated.
>
>Please point me to this problem.
>Thanks.
>
>Gan
Textbox.Controlsource will get updated when textbox loses focus (it seems to be part of internal code behind lostfocus event), so if you want to update field on your own discretion, you may issue when it's necessary:
REPLACE myyear With year(date()) In mytable
Edward Pikman
Independent Consultant