Limit on Combo Box columns ?
I'm using Access 2003 and resurrecting my ancient skills on a simple database.
I have a simple table and a query with 11 columns. I am selecting the key field with a Combo Box which picks up all the remaining columns from the query, then displays some of the results in text boxes. That's all fine except that I only seem to be able to pick up the first 8 columns, then the text boxes don't show anything when pointed at the relevant columns eg =Combo0.Column(9)
Am I doing something wrong, or have I hit an Access limitation ? Either way, is there a better (simple) way of doing this ?