>>>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.
Edward Pikman
Independent Consultant