related combo boxes on a form

G

Guest

I have a following parent child relation in my db

Client -> Project - > location

I want to have a combo box for client at top when user selects client, only
the projects belonging to that client should be displayed in the Project
combo box and similarly when user selects the project only locations
belonging to that project should be display in the location combo box.

How do I achieve this

Thanks,

Ashu
 
J

Jeff Boyce

Try searching on related or concatenated combo boxes, in this and the .forms
newsgroups, at Google.com, or in Access HELP. Access HELP includes code
examples...
 

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

Combo box question 3
How to select a description in a combo box but return a ID value 1
Filter Combo Box Options based on other Combo Box Selection 1
Pop up To confirm combo box selection 2
Combo box and parameter query 1
Multiple dependent combo boxes 1
using two combo boxes on one form 5
Combo Box selection / AUTO POPULATE combo box in a different form 2

Top