How do you know which record was selected in a DataGrid? I have programmatically linked the datagrid to a recordset of two joined tables. I think in the click event for the datagrid I should be able to use the bookmark, or the row, to ascertain which of the records was clicked on.
From there I want to pick up two of the elements of the recordset, and create a new join based on the two values.

This works with a combobox by using the index property - on a click, I set a variable equal to the index, move to the first record, and then count through to the one I want.

This seems like it should be just as easy with a datagrid - but I am baffled and bamboozled!