Access ADP Server Filter By Form two issues. "JBL" <johnlamb[ at ]tpg.com.au> 06.07.2006 06:41:42 I have two issues with the functionality around Server Filter By Form. 1. When I set the "Server Filter By Form" property of a form to yes, the form opens in Filter By Form view but is completely disabled and greyed out ie I can't type anything into any of the fields and none of the drop down lists function. I have to click "Apply Sever Filter" to view the form in normal view and then click "Server filter by form" again to activate the Filter by Form view a second time. When opened the second time like this it works fine. Is this normal behaviour or am I missing something? 2. When using Server Filter by Form to filter date fields, Access places # around the date when creating the filter. This happens whether you type a date into the filter by form field or whether you use a drop down. This makes the filter inoperable since SQL Server does not recognise the # around the date field. This makes it near impossible to use server filter by form to filter dates. I am using Access 2003 with an ADP connected to SQL Server 2000 developer version. Any assistance would be greatly appreciated.