>>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.