>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?
I get the same effect with a grid if the rowsource has changed. Try to remove the rowsource before running the query:
thisform.cboSelectPerson.RowSource = ""
SELECT * Query
Set Rowsource.
This has helped me in the past.
Christian Isberner
Software Consultant