Requery Combo boxes

  • Thread starter Thread starter Bunky
  • Start date Start date
B

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.
 
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!
 
Back
Top