Textbox Control Source not pulling value

[ChrisCione]

The control source for a textbox on my form is =[cboAcronyms].[column](2)


It stopped working; i.e., it's not pulling values from the 3rd column of the table that's the row source of [cboAcronyms].

It's worked in the past, and the only modification to the table was that I added a new row of data several days ago. I don't know if that's related, because I just noticed today that it's not populating the textbox. Any thoughts about this?



FYI: I changed the column to (1) and it worked; and I changed it to (0) and it works. But it won't pull the value from the 3rd (2) column.

 

[stumac]

It gives the value of the 3rd column of the combo box, not the table - check the column count property is at least 3 (the width's for the columns can be 0 if you don't want them to be displayed.)

If that is ok, confirm that the row source property is the table and not a query returning less than 3 columns and finally check the underlying data has value in those columns. - I would do this by changing the column width of the combo rather than looking at the source table, that way you can see as you select what you expect to be returned.

 

[ChrisCione]

That was it (column count was set as 1). Thanks!