Query field on form

[jamphan]

I have a list box in a form that controls the query results which will display a name when a certain region is selected. I would like for this to be incorporated into my form so when the user selects the Eastern region for example, John Smith will automatically be returned in the filed on the form since he is the person corresponding to this region. What is the best way to do this and also have the query filed linked to the same table my form is linked with? Thanks.

 

[neileg]

I'd create a combo box based on whatever table holds your region/person info. You don't need to store the person if there is a direct link to the region.

 

[jamphan]

How can I get it so when the user selects choices from the 2 other combo boxes, it will know that John Smith corresponds with the Eastern (cbo1) and Regional President (cbo2) selections?

 

[neileg]

That's a technique known as cascading combo boxes. Basically the selection in a combo is used as the criterion for the query on which the next combo is based. Do a search on cascading combos. I hope the postings haven't been lost.

 

[jamphan]

That will require the user to select John Smith from the combo box 3 correct. I want it to automatically populate his name in the field.