A
AkAlan
I am opening a bound form which uses a View for its recordsource. I'm using a
Where clause in the do.cmd line to open the form Most of the time there is
no problem but once in a while the Server Filter on the bound form will
remain stuck and the form will only open with data from the stuck value. I
tried setting the Server Filter to False in the on close event but that
sticks and then I get an error when trying to open the form the next time. I
solved the problem on one problem form by changing the record source from a
view to a stored procedure but I think there should be a better way. I'm
using XP Pro, Access 2003 sp1 and SQL 2000. Thanks for your help.
Where clause in the do.cmd line to open the form Most of the time there is
no problem but once in a while the Server Filter on the bound form will
remain stuck and the form will only open with data from the stuck value. I
tried setting the Server Filter to False in the on close event but that
sticks and then I get an error when trying to open the form the next time. I
solved the problem on one problem form by changing the record source from a
view to a stored procedure but I think there should be a better way. I'm
using XP Pro, Access 2003 sp1 and SQL 2000. Thanks for your help.