How do I refresh a control

When I advance a form from one record to the next, all of the bound
controls update fine. How do I get unbound controls to update, as
well? E.g. a drop-down lists records in another table that are
associated with the current record, but it seems to work only for
the first record in the table. When I advance the form to the next
record, that drop-down doesn't change.

Also, how can I force a change in one control on the form to
trigger updates in other controls? Their source values are changing,
but they keep displaying their original, old values. I have to
close the form and open it again to get the controls to show the
new values, and that's not right.
--
Helge Moulding
hmoulding at gmail dot com Just another guy
http://hmoulding.cjb.net/ with a weird name

Write code to trigger updating unbound controls on the form's
OnCurrent event.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxx


On 6 Sep 2005 13:54:22 -0700, "hmoulding@gmail.com"
<hmoulding@gmail.com> wrote:
[color=blue]
>When I advance a form from one record to the next, all of the bound
>controls update fine. How do I get unbound controls to update, as
>well? E.g. a drop-down lists records in another table that are
>associated with the current record, but it seems to work only for
>the first record in the table. When I advance the form to the next
>record, that drop-down doesn't change.
>
>Also, how can I force a change in one control on the form to
>trigger updates in other controls? Their source values are changing,
>but they keep displaying their original, old values. I have to
>close the form and open it again to get the controls to show the
>new values, and that's not right.[/color]

MLH wrote:[color=blue]
> Write code to trigger updating unbound controls on the form's
> OnCurrent event.[/color]

Thanks, I'll try that. Is there a reference somewhere that'll help
me figure out what triggers the various events? I gather OnCurrent
is triggered whenever the form displays a different record.
--
Helge Moulding
hmoulding at gmail dot com Just another guy
http://hmoulding.cjb.net/ with a weird name

On 6 Sep 2005 20:23:50 -0700, "hmoulding@gmail.com"
<hmoulding@gmail.com> wrote:
[color=blue]
>MLH wrote:[color=green]
>> Write code to trigger updating unbound controls on the form's
>> OnCurrent event.[/color]
>
>Thanks, I'll try that. Is there a reference somewhere that'll help
>me figure out what triggers the various events? I gather OnCurrent
>is triggered whenever the form displays a different record.[/color]

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
You are right about the OnCurrent event. The online HELP is
pretty good in covering events. An easy way to access it is by
pressing the F1-key after clicking on one of the many events
listed in the event properties window.