Can This Be Done

[extreme]

Please help Can this be Done
I have a form that gives you a list of clients I want to click on their box to open their projects.

If this can be done How

I have uploaded a pic so you can see what I mean

Thanks

 

[David Eagar]

Yes, you can have a continuous form (with id visible = no) and add a command button that opens project form with link of id to project fk and open specific records

 

[KeithG]

Yes use the double click event of the form. Once the user double clicks the record it become the current record.

 

[extreme]

Thanks for the replys I have figured this out I used his Code

Private Sub Form_Click()
DoCmd.OpenForm "Client", acNormal, , "ClientID = " & Me.ClientID
End Sub

Works Perfect

Thanks For your help