Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
List Boxes - I don't get it!!!
Message
From
26/02/1999 08:53:33
Susan Giddings
Aar Engine Component Services
Windsor, Connecticut, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00191736
Message ID:
00191885
Views:
52
>>I am new to VFP 6 so forgive the utter frustration. I can't get a simple combo box to work. Using the form wizard, I created a screen based on three tables: wcenters, wctypes, skills. wctypes and skills are lookup tables. Every record in wcenters MUST have a wctype. May or may not have a skill. I created a screen with other fields from wcenters and two dropdown list boxes one for the types and one for the skills. There are records in the tables. When the form runs the values for types and skills are NOT showing in the list boxes. The lists boxes are populated with the correct field values, but when I start the form or move through the records they are all empty. I want them to show the value assigned in wcenters. (I do NOT want the user to create new types or skills from within this screen.)
>>ControlSource: wcenters.wctype
>>RowSource: wctype.wctype,wctdesc
>>RowSourceType: 6 fields
>>BoundTo: .f.
>>(I tried it with BoundTo=.t. and they still didn't work.)
>>So, how do I get these guys to work?
>
>Hope this suggestion isn't insulting, but it's bitten me a couple times. Have you changed the ColumnCount from 0 (zero) to the correct number (I believe you're saying it would be 2). The stuff doesn't show up if the ColumnCount is zero (the default). You didn't list it in the properties you mentioned...
>
>HTH,
>Rich.

No suggestion is ever insulting! But the problem was far worse - Not only was columncount=0, but the type code fields were different sizes in each of the tables and different cases. DUH! Thanks for helping. Although I try to fight him off, the stupid demon lurks around here..... S:)
Previous
Reply
Map
View

Click here to load this message in the networking platform