click on row in subform to display record on form 1

[hefly]

I have a form with a subform. Both off the same table. tbl_A. There is currently, no child-master linking.

I just wanted to display all records on the subform.

I would like to click on a row in the subform sfrm_B to display that specific record on the form.

How can I do that? The matching fields on the form and subform would be RowID.

Thanks.

Hefly

 

[dhookom]

You could use code in the On Current event of the subform like:

Private Sub Form_Current()
    'assuming RowID is numeric
    Me.Parent.Filter = "RowID = " & Me.RowID
    Me.Parent.FilterOn = True
End Sub

Duane
Hook'D on Access
MS Access MVP

 

[hefly]

Duane:

Thank you! The code doesn't like

the first line, Private Sub Form_Current() is yellowed out,
and the line:

Me.Parent.FilterOn = TrueEnd Sub

"reds out" with "syntax error."

 

[dhookom]

Your code doesn't look like mine. End Sub belongs on a line by itself.

Duane
Hook'D on Access
MS Access MVP

 

[hefly]

Awesome! It works!!!

Thank you Duane!

Hefly