Changing the current record for bound controls

I have a datagrid control that shows the result from an Acces View and I
want to change the current record for other bound controls when the user
clicks in the different rows in the datagrid. Since the datagrid only
contains a subset of the possible current records for the bound controls.

Since the datagrid only shows a subset of the records, I can't use the
current row as the position in the binding context, but I have the primary
key easely accessible. Is there a way to get position when you know the key
to a table or must I cycle through each record and checking for a match?

Cato