I am having a problem with the boundcolumn control on a lookup table. The field is looking up values in a query and I am trying to get the field to store the value in the second field. I have used the wizard and also set it up manually and set my boundcolumn control to 2, but it keeps giving me the value in the first field.

I know that the solution is simple and I am overlooking something, any help would be appreciated.

Check the field property for number of columns...be sure it is set to 2...then set the bound column to 2.

Let me know how you make out. (Also, any values previously stored will remain there...they will not automatically refresh to the value in the second column...the setting will only apply prospectively)

jrwlkn is correct, but just because coloumn 1 is the "seen" column, doesn't mean it's the "bound column.
If you put column 2 as the bound column, I can't see any reason under the \sun why it wouldn't be.
Column widths property allows you to control which columns are seen irrespective of the bound column.
(I might be taken it for granted that you actually tried it as a link, to see which column is bound. your table results will show which column is bound also...?
but as jrwlkn said, your number of columns have to be at least the number of your bound column.
Please excuse any elementary pointers here.