OpenForm Method, wherecondition

[kevooo5]

I use Access 2003 and I'm having trouble setting the wherecondition for the Openform functions.
Usually it would look something like this

DoCmd.OpenForm "Contact", , ,wherecondition here

I want to be able to double click the field name for a specific record (contact name) on the projects form (which has contact name, dates, status, etc) and that would open the form contact and give me all the information for that specific contact but only that one.

so i guess the wherecondition should be something like
get the value from the field i double clicked (somebody's last name) and the open the form Contact but only display those records that match the last name with the one i double clicked.

I hope this is clear enough.
Any help would be greatly appreciated

Kevin

p.s., right now I have it set up so that when I double click the record on the projects form, it opens another form that asks for the persons last name. As you can imagine, i dont want to retype it everytime i need to check for somebody's personal information, especially since the information is right there stored in the field i just clicked

[ADezii]

I use Access 2003 and I'm having trouble setting the wherecondition for the Openform functions.
Usually it would look something like this

DoCmd.OpenForm "Contact", , ,wherecondition here

I want to be able to double click the field name for a specific record (contact name) on the projects form (which has contact name, dates, status, etc) and that would open the form contact and give me all the information for that specific contact but only that one.

so i guess the wherecondition should be something like
get the value from the field i double clicked (somebody's last name) and the open the form Contact but only display those records that match the last name with the one i double clicked.

I hope this is clear enough.
Any help would be greatly appreciated

Kevin

p.s., right now I have it set up so that when I double click the record on the projects form, it opens another form that asks for the persons last name. As you can imagine, i dont want to retype it everytime i need to check for somebody's personal information, especially since the information is right there stored in the field i just clicked

Place similar code in the Dbl-Click() Event in the [Contact Name] Field of your Projects Form:

Private Sub Contact_Name_DblClick(Cancel As Integer)
  DoCmd.OpenForm "frmContact", acNormal, , "[PrimaryKey]=" & Me![PrimaryKey], acFormEdit, acWindowNormal
End Sub