Situation:
I have form with two (2) datasheet subforms data1, data2 both subforms are based on the same record source. The reason for this is that the company commissioning this database dont want to have to scroll across to view records.
Problem:
The problem I am having is that I need some code that will allow a record to be selected (highlighted) in data2 when the corrosponding record has been selected in data1 and visa versa.
So far I have come up with the following code but it doesn't seem to work.
Dim rs As Object
On Error GoTo Form_Current_Error
Set rs = [data2].RecordsetClone
rs.FindFirst "[fileID] = " & Me.fileID
If Not rs.EOF Then [data2].Bookmark = rs.Bookmark
'
On Error GoTo 0
Exit Sub
Form_Current_Error:
Exit Sub
In advance thanks for your help and hopefully a solution is possible.