>Hi,
>
>Im using the seek command to seek a client name in a very large database with 1.7 m records. i have set the order to name2 which is the clients surname and then using the command SEEK locclient. locclient is a varible and the value is gotten from a textbox. I have tried several different syntax's but nothing will find the record. i am working in VFP 3.0 and i have tried go top.
>
>Please help
>
>thanks
>~Quinn

If you are not receiving an error, say, 'Index tag not found', then try to check the length of the name and compare it to the length of the clocvariable.

Include this on the syntax valid event of the textbox control:

SELECT table1
nLength = FSIZE('fieldname')
cLocVariable = STR(Thisform.TextBoxName.Value,nLength,0)
=SEEK(cLockVariable,'Table1','FieldnameTag')