>>>This is generic recommendation: it's much better to use cursor's alias as Grid.Recordsource, because here you can always check >record field value when you move grid (record) pointer.
>>
>>I am using the cursor's alias as grid.recordsource. I guess I should have noted that the grid is for the child table on the form.
>>I tried setting relationships in the dataenvironment i.e. grandparent -> parent -> child ( and not setting the listbox.rowsource programmatically as in the code above), but the drop-down list then includes ALL of the child records for all of the parents - not just those of the current parent.
>>Surely there is a way of getting the value of a particular field on the active row?
>>
>If you have cursor as a recordsource, then just check for appropriate cursor field value, which is always associated with active grid >row==cursor record.


Aha! That worked great. Thanks for your help.
Martyn