Requery Combo boxes


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.
 
Ad

Advertisements

Ad

Advertisements

B

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!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top