Open form if I click on data in a subform

[Jozo]

Dear All,
I have main form "Job" and one subform "Offer"
In a subform I have combo box Contacts.
How can I open form Contacts if I dbl click on a combo box in my subform where condition ID = Contacts!

Thank you in advance!

[wassimdaccache]

on event double click try to insert this code

 
Dim stDocName As String     
Dim stLinkCriteria As String      
stDocName = "Contacts"          
stLinkCriteria = "[ID]=" & [contacts]  
DoCmd.OpenForm stDocName, , , stLinkCriteria
 

Also you can you use from your toolbar create wizard button and ACCESS will create you the code


Regards,

[Jozo]

Dear!

I tried to insert your code but it is not correct.
Wrong: stLinkCriteria = "[ID]=" & [contacts]
Can't find this data!

Rgds

[Jozo]

I find answer...
DoCmd.OpenForm "Contacts", , , "[cID]=" & [oCustomer], , acDialog
ID - primary key in a tabele Contacts
Customer - name of the combo box in a subform "Offer"

Rgds....