Try
Code:
Private Sub Product_DblClick(Cancel As Integer)
DoCmd.OpenForm "12 Week Supply Status_Pastdue", , , "[Product] = '" & Me.Product & "'"
End Sub
Are records returned?
Next, try
Code:
Private Sub Product_DblClick(Cancel As Integer)
DoCmd.OpenForm "12 Week Supply Status_Pastdue", , , "[LPA] = '" & Me.LPA & "'"
End Sub
Are records returned?
Are you sure that you have records
Code:
WHERE "[Product] = '" & Me.Product & "' AND [LPA] = '" & Me.LPA & "'"
Both conditions must be TRUE for records to be returned.
Maybe you want records
Code:
WHERE "[Product] = '" & Me.Product & "' OR [LPA] = '" & Me.LPA & "'"