How to open report with two condition like this
First condition
is ok
but when I put second condition
the return massage, Access Run-Time error 2465. Can't find the field '|1' referred to in your expression appear
Code:
DoCmd.OpenReport ReportName:="Test4", WhereCondition:="ID = " & !ID And Me.[SEK_1] Is Not Null, View:=acViewPreview, WindowMode:=acHidden
First condition
Code:
="ID = " & !ID
but when I put second condition
Code:
And Me.[SEK_1] Is Not Null