I have a form with three subforms (picture attached). Two subforms show lists of records, one where a field is null, the other where the field is not null. The third subform shows the detail for one record. They all have the same key field. The list subforms only show the key field and one other bit of identifying info. I want to be able to double click the key field of a subform and have the detail show up in the detail subform to the right of the list subforms, not in a separate form. It should almost work like a web page where you click a link on the side and the detail shows up in the main part of the page. I have the three forms, they're just not linked.