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