Limiting values in a combo box based on the value selected in anot

G

Guest

I ahve form where the ulitmate goal is to select a person, however potentialy
they could be over 200 names to pick from, impracticle in a drop down list,
so I want to be able to get the user to select the the following, limiting
the value to applicable options in the next box (if you get my drift)

Site
Divison (only divisions for selected site allowed)
Department (only departments within divison, site cobination allowed)
Person (only peple in department, divison, site selectable)

How can I do this?

Is the a more elegant method of doing this than using cascading drop down
lists?
 

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

Filter values in a list dependent on value selected in prior field 1
Filtering a combo box on a subform using a value from the main for 3
Sort based on the name selected under the combo box 14
Load a recipient based on a value in a combo box 7
Wrong Combo Box Value Being Stored in Table 9
Contents of a drop down box based on the selection in another drop 1
Based on value from 1 combo box filter results in the next combo b 2
field equal to a value selected in a combo box 1

Top