Opening Form based on criteria not working unless selecting toggle filter button after form opens

[jlgray0127]

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

[June7]

Could provide your db for analysis.

[jlgray0127]

I can add a copy of the front end.
There are 3 different backend databases and it is also connected to Oracle, so I'm not sure if how helpful it would be, beyond the code I posted below. I am happy to oblige if the front end copy would help! Just wanted to share the setup before possibly taking time from you if it will not work.

[jlgray0127]

I ended up creating two new forms and it is now working correctly.
There was something weird going on with the formatting on these two forms, too. After I created the new forms, it's working pefectly! Thank you June!