Selecting records in one subform by clicking values in another subform

sal

Registered User.
Local time
Today, 02:50
Joined
Oct 25, 2009
Messages
52
I have a form with two subforms. I have been able to select records in a main form by clicking a value in a subform. But I am having trouble applying the technique to selecting records in subform "B" based on clicking a value in subform "A" (which is on a Tab Control).

Private Sub Control_Click()
Forms![Main Form]![Subform B].Recordset.FindFirst "[Control] = " & Me![Control]
End Sub

Error 438: Object doesn't support this property or method

Is this because I am not referencing something correctly or is it simply not possible?
 
Last edited:

Users who are viewing this thread

Back
Top Bottom