Create cascading combo box that will automatically update

P

Pamela

I have 2 combo boxes on my form. The first, InsuranceCoID, has its row
source which is a query that limits the combo box values to show only certain
companies that meet a criteria. I have it coded so that on a NotInList
event, a form opens so it can be added. I have a one-to-many relationship
between tbl_InsuranceCo and tbl_InsCoEmployee. I want to create the 2nd
combo box to cascade and show only the InsCoEmployees for the chosen
InsuranceCoID but it will have to update for any new InsuranceCoIDs that get
added. Obviously if a new InsuranceCoID is added in the form there won't yet
be any InsCoEmployees so I'll need to ability to code it as the first one for
the NotInList event. Thanks so much!!!
 

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

Help with cascading combo box 1
Clearing combo boxes and a text box 2
Add code to sort added combo box items alphebetically 1
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Combo box 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Cascading Combo Box - 2nd combo box changing 1st in previous recor 1

Top