This hasn't work, its showing a compile error. After reading about the DCount i'm unsure this will work, I'm wanting to display all the records with an exact match then use another if statement if the 1 above is true.
Will the DCount work for the above?
Thanks