Object Invalid No Longer Set/Complexity

[Guest]

Okay, I'm at the ropes now with my forms. Currently I have a form bound to a query, the information for this query resides at the top on the form and on the bottom I have a tab control. Each tab, for the most part, has information linked to other tables. One or two of the forms are connected via a query rather than a table.
When filtering all of this information by a unique identifier it works just fine in Access 2003. However in access 2000, when someone inputs new information or triggers an action query and they go to do a new filter the receive a message stating that the expression may be too complex and they get errors with "Object Invalid Or no longer set" Any solutions out there to solve this in access 2000?

 

[Wayne Morgan]

Since it is the older version not working, the first thing to check is patch
levels. Verify that you have the latest of each of these installed.

Office 2000 Service Pack (3)
Jet 4 Service Pack (8)
MDAC (2.8)
Operating System service pack

http://office.microsoft.com/home/default.aspx and click Check for updates
http://support.microsoft.com/default.aspx?scid=kb;en-us;239114&Product=acc2000
http://msdn.microsoft.com/data/downloads/updates/default.aspx
http://windowsupdate.microsoft.com