Thanks. I did not see the Bound Column. Now I am having trouble putting m.subdivsn+m.county+m.state as my countrol source. it wants a variable.

>Hi Brenda,
>
>No, the bound column does not have to be the first one. Just set it to 4 in this case and it should work fine.
>
>>I have a combo that has four columns: subdivision, county, state, Upper(subdivision+county+state). The first three columns show in the drop down, the fourth column is just used to sort the array in what the client's consider "correct sort order". My problem is that I need to bind to m.subdivision+m.county+m.state, but I do not want to show that column in the drop down. Does the bound to column always have to be the first? If not, how do i specify which column to bind to? If so, how do I not show the first column in the drop down.
>>
>>thanks
>>
>>Brenda