>>>>I'd like to use the InteractiveChange event to sequential search a table of about 8000 records. I'd like to be able to search the table as I type in the letters and display the record postion in a wait window. I've tried doing this but I can't seem to pass the results of the text field to the InteractiveChange event. It keeps telling me "Variable TEXT1 is not found".
>>>>
>>>>TIA
>>>>
>>>>/chris
>>>>close1@rtto.psu.edu
>>>
>>>This.Value will return current user entry text.
>>
>>
>>Ok, that helped. Now I have the this in the InteractiveChange event
>>
>>SELECT sponsor && Select table - indexed on UPPER(name)
>>SEEK UPPER(This.Value)
>>WAIT WINDOW TRIM(Sponsor.name) NOWAIT
>>ThisForm.Refresh
>>
>>When I run the form I get no errors but as I type in a string I get nothing in the wait window. If I change the wait window to
>>
>>WAIT WINDOW TRIM(This.Value) NOWAIT
>>
>>I see the value I'm typing in the wait window. Why isn't the SEEK working?
>
>I guess you should SET NEAR ON to get the nearest matched record.

That's it! Thank you!

/chris