General information
Category:
Forms & Form designer
>>>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only