I have a field in my form that will only show one of the following values:
CDN
USD
(NULL) - meaning be blank - empty field
I'm trying to create an if statement as follows:
([Forms]![fFindDups2]![FIle Curr]="CDN" And [Forms]![Profit Tracking 2]![Text108]="USD") Or ([Forms]![fFindDups2]![FIle Curr]="USD" And [Forms]![Profit Tracking 2]![Text108]="CDN") Or ([Forms]![fFindDups2]![FIle Curr] Is Null)
This returns the following error "Type mismatch" if the field is blank/empty
This works perfect if i leave out the last .....Or ([Forms]![fFindDups2]![FIle Curr] Is Null)
Can someone suggest how to write this if statement to include a blank/empty field?
thanks,
STeve