Lock one field based on selection in another field

[ojasg]

I am building a database that has two fields (amongst many other)

1 - Location
2 - Reason

There are like 100 reasons, but for a certain location there are only a few. I want to lock the list displayed by reason field to show only specific reasons based on users selection of the location. This way I can avoid inconsistent entries. There will be other field on this form as well.

The association between location and reason is in a table. So one field in the table is location and other is reason.

I would really appreciate any help on getting this accomplished. I can code in VBA so codes would help too.
Thank You!

 

[MajP]

you may set the values in the second combo
faq702-4289

 

[ojasg]

Works great! I tweaked a bit ..but the code is flawless!
Thanks a lot MajP.. You have come my rescue once more..

 

[missinglinq]

FYI, the concept is known as cascading comboboxes.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!