Has anyone ever had this issue?
I have one form where you double click on field and opens another form based on the form I just clicked on.
I have used this process for years and have not come across this before.
When the second form opens, it is blank. If I hit the toggle filter button and clear the filter, then click the toggle filter button again, it displays the records I would expect to see when the form opened.
Thoughts?
Private Sub PRODUCT_DESCRIPTION_DblClick(Cancel As Integer)
DoCmd.OpenForm "Gray_PS_Kitting_SubAs", , , "[JN_Txt] = '" & Me.JN_Txt & "' And [BN_Txt] = '" & Me.BN_Txt & "'"
End Sub