how to write the condition

[ABCD1234]

Hi,

I am new to access and learning. Can you see how I can make this check without giving me #error when running it. It will value it as #error on the report.

 
=IIf((InStr(1,[Sig_Aux_Info],"ICU ")>0) Or (InStr(1,GetSigAuxDrugCode([ITN],[PMP],"DRUGCODE_INFO"),"MSG QUALIFY")>0 And Trim([IV_METHOD_CODE])="10") Or (InStr(1,GetSigAuxDrugCode([ITN],[PMP],"DRUGCODE_INFO"),"MSG QUALIFY")>0 And Trim([NRS_STATION])="PSYH" And Trim([PHM_ORDERS!LATIN_DIR_ABBR])="REPLACE"),"Can't reorder on this form","____________ | ____________")

 Trim([NRS_STATION])="PSYH"  

I would like to check more stations to include SICU, MICU, etc. When I added those in as

 Trim([NRS_STATION])=("PSYH" or "SICU" or "MICU")

after running the report, the field value as #error.

Thanks

[MMcCarthy]

Try this ...

 
=IIf((InStr(1,[Sig_Aux_Info],"ICU ")>0) 
Or (InStr(1,GetSigAuxDrugCode([ITN],[PMP],"DRUGCODE_INFO"),"MSG QUALIFY")>0 
And Trim([IV_METHOD_CODE])="10") 
Or (InStr(1,GetSigAuxDrugCode([ITN],[PMP],"DRUGCODE_INFO"),"MSG QUALIFY")>0 
And Trim([NRS_STATION]) IN ("PSYH","SICU","MICU")
And Trim([PHM_ORDERS!LATIN_DIR_ABBR])="REPLACE"),
"Can't reorder on this form",
"____________ | ____________")
 

Mary