I am trying to do a pretty simple If statement in VBA and it is kicking out an error. I have researched it and it looks like it has to do with the fact the nz field is a date. Basically what I am trying to do is if a date is left null on the form to do one calculation and if there is a date do another calculation.
The code starts with: If Nz([First]) = True Then
[First] is defined as a Date in the Function. I was reading that the NZ returns a 0 value which VBA considers to be a date so I played around with the return value a bit without success. If I put in a date in the field then the calculation kicks out a result.
How do I write this first line of code when a date is involved?
Any assistance with this would be appreciated.