Hi I have tried several ways to get this to work and I don't understand what I am doing wrong.
I have a combo box on my main form "customer" the company box is "company owners name"
I have another form that I enter detail information into for the name selected in the combo box.
I would like to select the name in the combo box and than double click and have the detail form to open to the person selected in the combo box.
the information in the detail form that matches the combo box is " company or owner"
I have tired doing a embedded marcro, which will open when I double click the combo box but will not open to match the name selected in the combo box.
I have also tried the following :
Private Sub Company_Owners_Name_DblClick(Cancel As Integer)
On Error GoTo Err_Owners_Info_Button_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "company owner name details"
stLinkCriteria = "[company owners name]=" & "'" & Me![Company or owner] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Owners_Info_Button_Click:
Exit Sub
Err_Owners_Info_Button_Click:
MsgBox Err.Description
Resume Exit_Owners_Info_Button_Click
End Sub
Please help I know I should be able to do this but I just don't know what I am doing wrong... Thanks Angie