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?
>Maybe there is no records in the cursor?
>Also WHERE clause is not Rushmore optimizable because of ALLTRIM()
>
>>
>>I've got the following coming out of a LostFocus on a textbox
>>
>> Select * From Officer ;
>> WHERE Alltrim(Upper(LASTNAME))+Alltrim(Upper(FIRSTNAME)) = Alltrim(Upper(lname)) + Alltrim(Upper(fname)) ;
>> INTO Cursor Countit
>> thisform.lblSelectPerson.Visible = .t.
>> WITH thisform.cboSelectPerson
>> .RowSourceType = 6
>> .RowSource = "Countit.lastname, firstname, DOB, empcnty"
>> .ColumnCount = 4
>> .ColumnWidths = '150,150,75,150'
>> .visible = .t.
>> .ListIndex = 1
>> ENDWITH
>>
>>
>>Now, this is the same code (with different form element names, of course) I'm using in several places within this application. The problem is that the combobox is showing blank, and there is nothing to 'drop down'. Why is this combobox not behaving like the others?
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place