On opening a database I have created, I have an auto exec macro which runs
a
re****t to tell me when I have expired records in my database. This then
runs
another macro which if the expired records total more than 1 pings a pop
up
message to tell me i have expired records. Howver if there are no expired
records the macro runs and errors with a type mismatch error. Please help
the
macro code is
[Re****ts]![Expiring Records]![Total Expired]>0
i have tried zero's, "", Null and sums that = zero and it still doesnt
work.
HELP ME OBI WINDOWS KENOBI YOU ARE MY ONLY HOPE!
Thanks