Selecting a record from a subform to display on the mainform

[Pbear88]

Hello,

I have a mainform (DrForm)that displays all the details of a given record. I also have a subform (DrHistory)with in this mainform that displays a quick, table style of those same records, but only shows a couple fields. When I click on the subform record, I want the mainform to display the corresponding record details in the mainform. Since both form and subform are from the same recordset, they both have the "DR_ID" field. I'm sure this is done quite often and I've looked at quite a few examples, but I can't seem to get it to work. Should I be using the GoToRecord command or the RecordsetClone command? In my mind, it should be as easy as telling Access- "When I click on this record, take the DR_ID field from this record in the subform, and now go to that same DR_ID record in the mainform." I'm just having trouble with the syntax.

Thanks for any help you can supply.
Andy

[June7]

If you upgrade to Access 2007, there is an intrinsic form object that automatically provides that capability. It is called a Split form.

What code have you attempted?

Suggest code that sets the Filter and FilterOn properties of main form.

Me.Filter = Me.subform.DR_ID
Me.FilterOn = True

[Pbear88]

Thank you for your quick reply, and thank you for the information on Split forms. That will come in very useful, when I have to redesign most of these forms when we upgrade.

I found another post that actually helped a lot. Here is what ended up working. "DoctorsForm" is the name of the mainform and this code was placed in the Subform properties.

Private Sub Form_Click()
Dim rs As Object
Dim strLinkValue As String

strLinkValue = Me![DR_ID].Value

Set rs = Forms!DoctorsForm.Recordset.Clone
Rs.FindFist "[DR_ID] = " & strLinkValue & ""


Forms!DoctorsForm.Bookmark = rs.Bookmark


End Sub


Thank you again for your reply and help!