Dbl Click ListBox and have correct form for record open

[Zorkmid]

Hi there,

I have a series of forms for users to enter data about isolated patients. The first form in the series contains a listbox linked to a query that displays all of the patients that are currently present and under isolation at the hospital. I have two tables with a parent-child relationship. The parent table contains info about the patient (tblPatient), and the child table (tblCase) contains info about the specific visit.

I would like users to be able to double click on a specific record and have that event bring them to a form that allows them to specify an enddate and edit certain aspects of the record. I think this needs to be a form with a subform in it.

I have looked online and in this forum and I cannot get the dbl click code to bring up the relevant records. I have seen examples of how to do this, but I can't wrap my head around how to code it.

Example: http://www.access-programmers.co.uk/forums/showthread.php?t=147076

-Z

 

[dcb]

Hi

Assume we are speaking about the form start.
Done a few things
Have a look at the code
Have a look at the modified fields on your form it opens