Combo boxes to show sub categories

J

Jenny

Hi

I have a problem figuring out how to design my combo boxes.

I have a number of clients, and within each client, a number of divisions.

I have a tblclient with the field [client]
and a tbldivision with 2 fields [client] and [division] so their
relationship is ONE tblclitnt TO MANY tbldivision

In my combo boxes in forms, what code do I need to get the division combo
box to only show divisions of the selected client (already selected on the
form in a previous combo box)?

I hope this makes sense

Many thanks for your help & Happy Friday!
 

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

Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
Dependent combo boxes issue 1
Dynamic Naming of Form Button 3
Combo box 0
Combo Box Question 4
Connecting combo boxes 1
Change Form's Recordsource with SQL Statement? 0

Top