>Hey Happy Peoples
>
>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?
In my view, it's better to set the RowSource of the combo once initially, and then use the Requery method to have it reevaluate when something has changed. But I don't think that's the problem here.
What's the ControlSource for the combo? I've seen issues sometimes when the ControlSource is a form property, or when the ControlSource and RowSource conflict in some way.
Tamar