I have a list form and want to be able to click on a single item and then open another form with the detail for that item in the list.
The code I am using is below. However I get a type mismatch error. The data type for the InvoiceNo fields do match, so I am confused as to why this is not work. Except for the fact that my fields are not integers they are text fields. Any help is appreciated. Thank you!
Private Sub InvoiceNo_DblClick(Cancel As Integer)
If IsNull(InvoiceNo) Then Exit Sub
DoCmd.OpenForm "frm_invoice_sub2", , , "InvoiceNo=" & InvoiceNo
End Sub