query column not populating text box.

[mejia.j88]

Hi all,

I have a query that is used to populate some fields in a form.
the query has 9 columns: 0,1,2,3,4,5,6,7,8.


when i update a combo box (field 0) the query should populate the rest of the text boxes using colums 1-8.

the problem: column 8 is not populating.
every other text box is filled. For the text box control source, i have used
=[query name].[column](#) where # is the column number respectively.

so for the text box =[query name].[column](8) it does not show anything (if i run the query, all data is there)

if in that same text box i put =[query name].[column](1) then it does show something, basically, all of them show except column 8.

has anyone experienced something similar?
below is my sql for the query:


SELECT etchlot.EtchLot, etchlot.PartNumber, etchlot.LotNumber, etchlot.WorkOrder, etchlot.EtchNumberStart, etchlot.AcidBatch, etchlot.EtchSink, DIODES.DIE_SIZE, DIODES.DIE_CUTFROM DIODES INNER JOIN etchlot ON DIODES.P_NUMBER = etchlot.PartNumberORDER BY etchlot.EtchLot DESC;


diodes.die_cut is the one i want to show that is not working.
also, i have tried to make another column (number 9) and it also does not work.

if i move die_cut to another column, then it does show.

any ideas?

thanks
-j

[June7]

EDIT: misread post, removed comment

[pbaldy]

Make sure the Column Count property of the combo is 9.