Order of events

[Bob]

My question regards the order in which events are executed.

In my form there is one multi-select listbox and one subform.

The events that have to take place are requery of the subform after update
of the listbox. This is working OK.
Secondly, I also have tried to build an event that updates the backcolor of
the labels in the header of the subform (based on the selection in the
listbox). For this I have tried to put the code in the "on open", "on load"
or "on got focus" event of the subform. This is not working, somehow the
requerying of the subform does not execute an update on the label
formatting.

The backcolor update does work when I open the subform separately from the
mainform, so I must be doing something wrong with regard to the order of
events.

The backcolor update does also work when I put the code in the "on timer"
event (because it keeps on repeating the code at the set interval).

So my question is how to get the requery afterupdate event to include the
update on the backcolors of the labels in the header of the subform.

Thanks,
Bob

[Michel Walsh]

Hi,

Use the Current Event of the subform?

Hoping it may help,
Vanderghast, Access MVP

"Bob" <n...@mail.com> wrote in message news:aqbn2o$nhm$1...@reader13.wxs.nl...