>>>>I left out the part between the Select and the 'Visible = 1' where I check reccount() on the cursor and I've walked the code many MANY times and yes, there are records in the cursor. For testing, I'm using a lname+fname combo that has 5 records. This label and combobox only show when there are multiple selections
>>>>
>>>>
>>>>And the ALLTRIM knocks out Rushmore even if it's part of an index?
>>>>
>>>
>>>What is actual index expression?
>>
>>ALLTRIM(UPPER(LASTNAME))+ALLTRIM(UPPER(FIRSTNAME))
>
>You do realize that you can get unexpected match if Lastname+Firstname matches some other Lastname?
>
>I don't think Index like that can be created in VFP 9 because of variable size of the index
>It should be
>UPPER(LASTNAME) + UPPER(FIRSTNAME)
>* and WHERE clause
>UPPER(LASTNAME) + UPPER(FIRSTNAME) = UPPER(PADR(m.LASTNAME, LEN(LASTNAME))) + UPPER(PADR(m.FIRSTNAME,LEN(FIRSTNAME)))
>
Well, I changed the tag to PADR(UPPER(LASTNAME),25)+PADR(UPPER(FIRSTNAME),25), but it makes no change vis a vis the combobox not working, which is my original problem
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place