>>Hello,
>>
>>I try to use autocomplete in a textbox but I am missing something?
>>
>>First I create the table MyAutoComp.DBF with the Source and Data fields according to the structure of AutoComp.DBF, fill the data values and set use that table as AutoCompTable. I replaced all "Source" with "STREETS" in the Automplete table as well.
>>
>>
>>THIS.txt.AutocompSource = "STREETS"
>>THIS.txt.AutocompTable = "MyAutoComp.DBF"
>>THIS.txt.AutoComplete = 1
>>
>>but I don't see it working, it does not show any values that I have in the table.
>>
>>Any ideas what I'm doing wrong?
>
>Did you create the index too? By the way, there is a bug with the index expression, if your entries are longer than 30 chars, they will repeat in the table, change the index expression from:
>
>UPPER(source+LEFT(data,30))+PADL(count,8)
>
>to maybe:
>
>UPPER(source+LEFT(data,200))+PADL(count,8)
>
>Carlos
Yes, I did create the index also, after checking the correct table structure of the AutoComp table. I still don't know what happend, but I created now a form with a grid to do it differently.
Christian Isberner
Software Consultant