I borrowed the customer phone list form from the Northwinds.mdb.
It lists customer alphabetically. I added some code that causes another form to open when clicked on the customers last name.
How can i make this second form open to the record pertaining to the last name that is clicked and not this first redord thats in the table. here is th code i am using to open the second form, how can it be changed?


Private Sub CustomerName_DblClick(Cancel As Integer)
On Error GoTo Err_List0_DblClick

    Dim DocName As String

    DocName = "frmCustInfo"
    DoCmd.OpenForm DocName, , , , , , frmCustInfo


Exit_List0_DblClick:
    Exit Sub

Err_List0_DblClick:
    MsgBox Err.Description
    Resume Exit_List0_DblClick
End Sub

Dim DocName as String
Dim strLinkCriteria as String

strLinkCriteria = "[CustomerName] = '" & Me.CustomerName & "'"

DoCmd.OpenForm DocName, , , strLinkCriteria

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Oh, I forgot to include

DocName = "frmCustInfo"

before the strLinkCriteria line.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks so much, it works perfectly...