Access update problems

R

Roland Verrinder

Hello,

I have a large application which I have just upgraded from
Access97 to 2002.

I have many forms that are based on queries which have
criteror links to controls on the respective forms. All
Have operated well on Access97.

On Access 2002, when applying a filter to any form fields
and then removing the filter with Docmd.RunCmd
acCmdRemoveFilterSort or Form.FilterOn=false, the
criterior links to the form fields are disabled. All code
to requery or refresh the datasource fails. A call to
Docmd.RunCmd acCmdRemoveFilterSort also activates the
Advanced Filter panel.

I have reproduced this behaviour on a number of computers
and operating systems and on raw databases with both
linked and local tables. All behave the same.

Can someone please enlighten me on this behaviour. It is
proving a nightmare in this upgrade.

Roland
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering on Linked Tables 1
Data Has Been Changed / SQL Trigger Problem 2
Refresh data in sub forms when one sub form is edited 8
Subform Filter by Form not filtering when using Access built int Filter by Form 4
Criteria CHOOSE problem and using Operator 1
Specific Values List Missing 1
access updates wrong record 6
Link subform with main form 0

Top