Filter a form based on a crosstab query value

[AriannaVV]

Hi everyone. I need help on the following issue, pls.
I have a crosstab query
sql: TRANSFORM Max(qry_Files.FileDateLastModified) AS MaxOfFileDateLastModifiedSELECT qry_Files.FileId, A2018.BranchName
FROM qry_Files LEFT JOIN A2018 ON qry_Files.FileId = A2018.BranchID
GROUP BY qry_Files.FileId, A2018.BranchName
PIVOT qry_Files.StatusFinal;

I created a form based on the query above and now i need to open another form named frm_ReportsOPEN, in specific record depending on a column value of my first form.
On a column value field and on mouse Down event i tried to use the code below:
DoCmd.OpenForm "frm_ReportsOPEN", , "MaxOfFileDateLastModified = #" & Me.Primary & "#"
but it doesn't seem to work. Filter is on and both fields are date fields.

What should I do ?
Thanks u!

 

[xenou]

You can test this:

DoCmd.OpenForm "frm_ReportsOPEN", , "MaxOfFileDateLastModified = #" & Me.Primary & "#"

just use a real date that should work:

DoCmd.OpenForm "frm_ReportsOPEN", , "MaxOfFileDateLastModified = #10/24/2017#"

If it works, you know the problem is in your calling form, and if it doesn't work you know the problem is in the form you are trying to open (or both forms).