form opens another form
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