I have created a small database in Access 2013 with several web forms that are shared through a SharePoint site. I have a continuous form with a dropdown box in the header which acts as a filter to allow the user to filter the records. The AfterUpdate macro uses the following code:
SetFilter
Where Condition = [CLASCODE]=[Forms]![Attendance]![cboClass]
This works great on one form which uses a string value to filter the form (both in Access and on the web). However when I try the same approach on a similar form using a date value it will work in Access but NOT when I try it on the web. I get an Error 2950 saying "failed to filter result". Has anyone found a work around for this - or - found another way to filter a web form by a date? I appreciate any thoughts. Thanks!
SetFilter
Where Condition = [CLASCODE]=[Forms]![Attendance]![cboClass]
This works great on one form which uses a string value to filter the form (both in Access and on the web). However when I try the same approach on a similar form using a date value it will work in Access but NOT when I try it on the web. I get an Error 2950 saying "failed to filter result". Has anyone found a work around for this - or - found another way to filter a web form by a date? I appreciate any thoughts. Thanks!
