Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo box not Combo'ing
Message
From
18/03/2019 02:12:24
 
 
To
15/03/2019 15:04:29
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01667274
Message ID:
01667317
Views:
47
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform