Can you just help me with this syntax please?
Im trying to filter my form where the field USER = "...to be allocated" AND where the AllDateTU field is less than an unbound date field on my form called AllocationDate
This is what I tried but Im getting a 3175 runtime error which Im stuggling to identify with. thanks in advance.
Im trying to filter my form where the field USER = "...to be allocated" AND where the AllDateTU field is less than an unbound date field on my form called AllocationDate
This is what I tried but Im getting a 3175 runtime error which Im stuggling to identify with. thanks in advance.
Code:
DoCmd.ApplyFilter , "(USER = '...to be allocated')AND (AllDateTU <#AllocationDate#)"