|
I am trying to write a form that will display a steadily refined list
of names. I have a variable edit and a variable lookup list box. As
the user types in a name I wan the list in the list box to update by
dropping all the invalid names. For example, if my list of names is: John Doe Jason Kramer James A Garfield James Joyce And the user types J, nothing will be changed, but if the user types Ja, then John Doe should be dropped. The problem I am running into is when the user gets to the point that there is a space in the name. After the user types a space, the cursor jumps back to the first position in the Variable Edit and the trailing space is dropped. So far the only way I can find to work with a space is to type the first and last name together (JamesJ) and then go back and add the space (James J). The is probably not going to go over well with the end users. I am currently using an ON KEYPRESS EEP that starts by getting the TEXTVALUE of the variable edit and putting it into a variable (GETPROPERTY vesearchbox TEXTVALUE vmyvar) and then using vmyvar to refine the list: SELECT COUNT names INTO vnamecount FROM mytable WHERE fname = .vmyvar. Does anyone know of a way to handle a name (or other string) with a space in it and retain the space using ON KEYPRESS? I can rewrite the form so that the search limit is entered and then a button (or an on exit EEP is fired) to trigger the search, but I thought that a slicker implementation would have the list being refined automagically (at least as far as the end user is concerned). Thanks, Jason -- Jason Kramer University Archives and Records Management 002 Pearson Hall (302) 831 - 3127 (voice) (302) 831 - 6903 (fax) |
