MattBaldry
Self Taught, Learn from the Forums
- Local time
- Today, 23:45
- Joined
- Feb 5, 2019
- Messages
- 331
Hi all,
I am trying to apply a form filter on a continuous form on a reset button. When I save the form filter, it gives me the below.
(Year(tblAppointmentList.AppointmentDate)=Year(Date()) And DatePart("ww",tblAppointmentList.AppointmentDate,0)=DatePart("ww",Date(),0))
But when I apply this to the button via VBA, I get the "can't find the field '|1'" error. I assume this is something to do with the DatePart section, but I cannot get it to work.
Can anyone point me into the right direction please?
~Matt
I am trying to apply a form filter on a continuous form on a reset button. When I save the form filter, it gives me the below.
(Year(tblAppointmentList.AppointmentDate)=Year(Date()) And DatePart("ww",tblAppointmentList.AppointmentDate,0)=DatePart("ww",Date(),0))
But when I apply this to the button via VBA, I get the "can't find the field '|1'" error. I assume this is something to do with the DatePart section, but I cannot get it to work.
Can anyone point me into the right direction please?
~Matt