Michael,
John Engwer has a nice way of doing something similar to what you are wanting to do in regard to the selection of an item from a dynamically changing list. Essentially the technique involves creating a view or temporary table which changes after each keystroke. John sent me a sample of this – I presume that he would be happy to do the same for you. (I could give you my version but it has been modified and is now a little complicated, and would need some more documentation, but if you are stuck let me know.) Regards, John Docherty From: [email protected] [mailto:[email protected]] On Behalf Of Michael J. Sinclair, MD Sent: Tuesday, 7 April 2009 11:01 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Is there a Form Control mixed with WalkMenu?? Hi all, I am not sure which control does what I need, but I think there is one. Here is my scenario... I want to get a client number from another database, and assign the value to a variable within a form. I have about 25,000 clients in the foreign database. I can use sconnect and stattch to get access the table without any problems. Now I want to have an object on a form where my user can start to type in the last name. As the user starts to type the last name (Smith), I want the control to "jump" to the first row that has a lastname with the letter "S" as the first character in the lastname. Ideally the control would then show a few more rows below the first row where each row has the lastname starting with the letter "S". Then, when the user types the letter "M", the control would now jump to the first row that has a last name that starts with the letters "SM". Then the user would type in the letter "I".....you get the idea. After typing in SMITH, the user should then be able to use the up and down arrow keys to scroll to the row that also has the first name (displayed right after the last name on the same row). When the user finally gets to the row that has the last name and first name that they are looking for, the user should be able to hit the [ENTER] key which would select that row, and return the client id number (taken from the foreign database) to the control's variable. Then I could use that variable for whatever I need. If it makes a big difference, I could append the all of the client data from the foreign database to this database before running the from. Which control if any can do that? Mike
