combo box not update d

[Fred Loh]

on my form i have a date field that is updated by users. on the form is a
combo box that has the date field as one of its column. after the date field
is updated (changed) by the user, when the combo box is opened, the combo box
still shows the old value of the date field instead of the new value entered
by the user.

i tried to use "me.mycombo.requery" in the combo box's gotfocus event. then
i tried using only "Requery" in the combo box's gotfocus event. i also tried
to use "me.mycombo.requery" in a button's onclick event with the button on
the form. but none of these method works. the combo box sometimes does and
sometimes does not show the latest change made by the user. how can i ensure
that the combo box consistently shows the latest date (data)?

i am using Access 2002.

thanks for your help.

 

[ruralguy via AccessMonster.com]

Changing a control on a form does not change the value in the underlying
bound RecordSource until the record is saved, either explicitly or by moving
to another record or closing the form. Save the current record first and then
your Me.mycombo.requery should work just fine.