Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo in grid doesn't show value
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01519540
Message ID:
01519614
Views:
12
>>>Change WHERE clause in ComboBox rowsource:
>>>
>>>WHERE TheField = ?thisform.nLevelId INTO ...
>>>
>>>and make nLevelId to be a property of the form.
>>
>>Ok, everything seems to work Ok with few problems:
>>
>>1) When I select an item from the combo, it does not display until I navigate out of that column
>
>AFAIK this happens when you have RowSourceType = 6 && Alias
>
>>
>>2) When I add a blank record to the grid, I don't see I added it - may be I should automatically select the first level in the list? Or how can I make another visual clue?
>
>Make RowSource to be:
>
>SELECT DisplayedField, ValueField FROM SomeCursor WHERE LevelId = nLevelId;
>UNION;
>SELECT "Please choose a value", 0 FROM SomeCursor;
>INTO CURSOR cboCrs
>
Good idea. I added setting the first item automatically when I add blank row for now - I think it's OK and they will be smart enough to change if needed.

So, this page almost works, I need to fix another form that I invoke by Edit Block Details button.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform