Requery Combo boxes

[Bunky]

On my form I have two combo boxes, Supervisor and Specialist. Obviously, the
Specialist is driven by the Supervisor that is chosen. You have many
Specialists to one supervisor. These both are populated by queries. The
first time a selection is done, everything populates correctly. When a
different supervisor is chosen, it does not requery for the specialists
associated with the new supervisor selection. I have put in requery
statements on the Form - On Current event and tried coding them in the
combobox after update event. I cannot get them to fire again. I tried to go
the website that Mr. Sheridan suggested on another post but it is blocked by
our system. Any help will be greatly appreciated.

 

[S.Clark]

Instead of OnCurrent, use the AfterUpdate of the Supervisor control.

 

[Robert_DubYa]

Are you using docmd.requery?

 

[Bunky]

I tried that and it did not work.

Instead of OnCurrent, use the AfterUpdate of the Supervisor control.

 

[Bunky]

No, I was just using ComboXX.Requery

Are you using docmd.requery?

 

[Bunky]

I found it! I do not know why it works but it does.

On the driving Supervisor Combobox under the after update event I coded the
following.

Combo47 = Null
Combo47.Requery
Combo47 = Combo47.ItemData(0)

Thanks to all who answered!