datacombo fails with more thar 20 records ?!!!

[antoniojesus]

Hi there her's my prob.
I have a datacombo that uses table1 to show 20 records, so that;
Rowsource=AdoTable1
ListField=Desc

The data source for this datacombo is table2
so that;
DataSource=adotable2
DataField=ID
BoundColumn=ID

In table1 and in Table2 i have a field called ID that is integer.

Now the prob.
If table1 has more or less 20/30 records everthing works fine and when i move in adotable2 recordset the info Desc if showed nicelly, but when i put 200 records in table1, the datacombo fails to show Desc, however when i chose one item from the list
and save the record the info is saved, but when i move to the record again it does not show anything. even strangiest is the fact that if i chose one of the first 20/30 items displayed in the datacombo, it all works.

I would really apreciate help on this,
thanks a lot for reading

António Jesus

 

[dcusick]

Has anyone ever come across this as well? I am having the same problem but I can get through about 50 records instead of 20. I have two datacombo boxes, one will display 53 of 95 and the other will display 50 out of 127 records... The simple matching stops there too.. If I start keying in the alphabet, the datacombo is in alphabetic order, the selector moves down until I hit that record 50, where it will stop moving down the combo box.. Any help would be very greatly appreciated... VB6.0 Professional.

Thanks
Doug