I guess I am not either. Why would you want the combo box to do that, and not the user selects which subdivision, county and state they want, and the table shows those records.

You might want to add another field to the subdivision, county, and state table as a unique index, that can be stored in the other table, then you will put the controlsource for the combobox to the other table. lookup code. That should do what you want.

>Sorry, I am not understanding. I have three fields in my table - subdivision, county, and state. I want to match those three fields to a item in the array that is the datasource for my drop down. I can add a column to the array that has all the valid subdivision+county+state, but I do not know how to code the controlsource of the combo so that when the form is displayed, the combo is showing the correct subdivision, country, and state for the current record in the table.
>
>