Hi,
On a form, when field A is changed, I update field B automatically by
Setfocus to field B, and then assign it with another value. This is
handled in the field A AfterUpdate method. After updating field B, I
want the form to continue normally. For example, setting the focus to
where I clicked last. Or in the case that I click that next record
button, the form should show the next record. Is there a way to do
this? Currently, when I click on the next record button, the form stays
at the current record. I then have to click it again to move to next
record.
Thanks,
Tony
Tony - 16 Dec 2005 07:07 GMT
I found the answer from Marshall. I have always thought that a control
has to have focus before it can be modified, which was weird. When I
remove Setfocus, the code works fine. Thanks everyone.