Updating a form with ServerFilter set

[Guest]

I am converting a MS Access database to a Access Project to see if the
performace and functionality is better. My current Access DB is a front end
to a MS SQL 2000 database using linked tables so it should be a perfect
candidate to covert to a Access Project, but I have run into a behavior
difference.

After I coverted to an Access Project I noticed a performance problem with a
form that used the Filter property to select records on a table with 13,000
records. My guess is that the Access project is fetching all records before
applying the filter. So I converted the code to use the ServerFilter
property and that solved the performance problem but caused another problem.

Now when I change a data element on the form to a value that causes the
record to no longer match the ServerFilter criteria, I get an error message
when the record is being updated. The message warns me that the data will be
added to the database but won't be displayed in the form because it doesn't
match the criteria in the underlying recordsource. This is a great warning
the first time, but I don't want my users to see it every time the make such
an update. Is there a way to supress the message or another way to filter
the records that gives good performance and doesn't have this issue.

Thanks in advance

 

[Guest]

I'm a bit disappointed that my post hasn't gotten at least one response. Is
there no MVP out there that can address this issue? or at least tell me I'm
out of luck and there is nothing that can be done. In which case I'll just
stick with having and Access DB front end instead of converting it to an
Access Project.

Thanks in Advance!!