I have created a Query By Form. The results are in a Subform. I would like, on the same form, to bring up the record for the highlighted line in the subform.
You need to some how create a way to load the form database based on an ID or something. When double click on the ID, just reset/reload the form with new data based on that new ID.