click record to open a form with additional information on that record

[eraengineer]

I would like to click on a record on a multiple items form and have it open a form with additional information about that record. I image there will be some linking to of queries and tables but I can not seem to figure this one out.... I want to click an image on my form and have it open a new form displaying the same image.

[eraengineer]

I tried the string below, but I get a compile error in hidden module: myform
DoCmd.OpenForm "myForm",,,"ID=" & Me.ID

[rankhornjp]

I tried the string below, but I get a compile error in hidden module: myform
DoCmd.OpenForm "myForm",,,"ID=" & Me.ID

Maybe this will help.
I have an unbound list box on frmMain that has a list of my clients (from the People table) On the Double Click event I run:
DoCmd.OpenForm "frmPeople", acNormal, , "id=" & Me.lstClients.Value

This opens another form (frmPeople) that will show that persons information (address, phone, email, etc.)


The Row Source for the list box is:
SELECT People.ID, People.pLname AS [Last Name], People.pMi AS MI, People.pFname AS [First Name], People.pDOB AS DOB, People.pSSN AS SSN, People.pInactive FROM People WHERE (((People.pInactive)=0)) ORDER BY People.pLname;

Then I set my first column width to 0" so that the People.ID field isn't shown.