Folks
I can't get VBA to pick up duplicate dates. Here's my code (used within the Before Update event of the relevant field):
The table is called 'ReviewDateTable' and the relevant field is called 'ReviewDate', as is the relevant field on the form. The field in the table and the field on the form both have the format 'dd/mm/yy'.Code:DCount("ReviewDate", "ReviewDateTable", "ReviewDate = #" & Me!ReviewDate.Value & "#")
What can I be doing wrong?
Thanks
Remster