General information
Category:
Forms & Form designer
I have a form with a grid that displays names and addresses. When users take a call they need to see if the person calling already has an existing record. The company will not use id# so we search by name. I have an index namekey that is comprised of lastname and firstname. I have a textbox on the form. When a call is taken the user enters the name in the textbox. In theory as a name is entered the pointer should move to the closet record. I have the keypress for the textbox set as follows.
I have 2 issues. First, the grid seems to react to only every second keystroke.
Second, is there a way to change the display font (or some other form of highliting) only on the record that is the closet match to the keystrokes that have been entered to this point.
In other words I would like the closest match to be in the center of the grid and displayed in some manner that will bring attention to that record.
KEYPRESS
LPARAMETERS nKeyCode, nShiftAltCtrl
set talk off
set near on
local addnew
select members
set order to tag namekey
addnew=alltrim(thisform.add1.value)
seek (addnew)
thisform.new.visible=.T.
thisform.grid1.refresh
Thanks
Dennis
Next
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