>>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?