>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