>>>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