update problem

A

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.
 
J

Jen

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top