>>>>I removed unneeded dots, though some people like to leave them.
>>>>
>>>>Anyway, the code looks fine to me, can you trace it to see, what it's doing? I think you have data problem, not a bug in this little piece of code.
>>>
>>>Thanks for the clue. BTW the Shapename field contains a sys(2015) value
>>
>>Do you have shapes on the form with random names?
>
>The shapes are named by sys(2015)

How many records in the table meet the date criteria? Can you go through the code in debugger?