If receiving a type mismatch error for the following code:
dim straWarehouse As String
straWarehouse = IIf(Nz(rsta.Fields(5)), rsta.Fields(5), "")
When executing the code, value for rsta.Fields(5) is "Tempe"
I don't understand what is causing this error. Can the Nz function only be used for variable types of variant?