Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Access Form Filter doesn't work

Author  Topic  solai Starting Member 6 Posts Posted - 2006-05-18 : 09:15:34 Hello All, I have an Access application in which there is a form that uses "RecordSource" on the Open Event. The Access as a connection to SQL Server 8.0. Now on this form the form footer consists of a =SUM() control, which works fine at the beginning. But when we try to a filter or sort on the detail section controls, it shows #error. Did anyone come across this problem. Any pointers will be greatly appreciated. Thank you. -solai