update problem

[Art Vandaley]

Hi.

I have a code for a form like below:
----------------------------------------
Private Sub Calendar8_Click()

Text1.Value = Text159.Value
Text2.SetFocus

End sub
----------------------------------------

Control source of Text159 is something like "
=Format([calendar8]-Weekday([calendar8];2)+1;"dd/mm";2) "
Control source of Text1 is a field of related table.

Everytime I click the calendar Text1 shows the date of prior selection. For
example:

I click on "13rd April 2006" Text1 shows prior selection,
I click on "14th April 2006" Text1 shows "13rd April 2006"

Is there a solution to provide text1 to show most current selection on the
form.

Thanks a lot for your help. Regards.

 

[Jen]

Sounds like Text1 is updating before Text159 has updated. why not assign the
value in Text159 directly to Text1 in that click event?