Help with cascading combo box

P

Pamela

I've tried the various help references online for creating these but am
having trouble in this situation:
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.
Any help on how to accomplish this would be much appreciated! Thanks!!!
 

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

Create cascading combo box that will automatically update 0
Clearing combo boxes and a text box 2
Add code to sort added combo box items alphebetically 1
Creating a Search using a combo box and then creating a report. 4
Dynamic Naming of Form Button 3
Combo box 0
Combo or list box 0
Cascading combo boxes - are they able to do this? 6

Top