Doing an If clause with DLookup genereally means usin a comparison of the lookup result to a value using the equals function. Most other functions do not tend to work well with DLookup and especially not the IF ISNULL structure.

This entry was posted in Access 2007 problems/solutions, Uncategorized and tagged . Bookmark the permalink.