Bounding Column

[tanyapeila]

Still can't get this....

This is my table

This is my form. I want the user to be able to select by the State Abbv, however I want the "DArea" value to show up
AND the State Abbv are not in Alpha order even through they are in the table??

[alansidman]

Set up a combo box on your form. In the rowsource for the combo box, select your table with the states. Select the two fields you wish to have in the combo box. Set the sort in the query behind the combo box to Ascending. Set the DArea as the bound field for the lookup.

Look at this tutorial for further clarification: http://www.datapigtechnologies.com/AccessMain.htm

Scroll down to the section on combo boxes

[tanyapeila]

Thank you that worked. For some reason I always try to create the combo boxes in the Table not the Form

[alansidman]

Why you should always create combo boxes in a form and not in a table

http://access.mvps.org/access/lookupfields.htm