>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
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?
If it's not broken, fix it until it is.
My Blog