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:
01519601
Views:
21
>>>>Could you send me this form ?
>>>>Of course if there is no sensual information and no firm secrets :-)
>>>
>>>I seem to be now having problems when I add a new record to the grid (I have a button to add new row). I then go to combo level and try to pick up the Level. At this point I got an error about nLevelID is not found. Also, my selected value doesn't show up until I get out of the column.
>>>
>>>Do you see the same problems with your form?
>>
>>As far as I see- no.
>>But I have one command button with these lines:
>>
>>APPEND BLANK IN crsMainGrid 
>>thisform.Grid1.Refresh()
>>
>
>I have
>
>SELECT rsTSBlocks
>APPEND BLANK 
>replace TemplateID WITH thisform.oCurrentNode.Values('TemplateID').Value
>this.Parent.grdSeatBlocks.Refresh()
>this.Parent.grdSeatBlocks.SetFocus()
>
>Do you see what may be a problem?

Nope.
O!!!!!!!
Maybe ComboBox try to requery its source.

Change WHERE clause in ComboBox rowsource:
WHERE TheField = ?thisform.nLevelId INTO ...
and make nLevelId to be a property of the form.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform