Microsoft KB Archive/193480

= OFF97: Undo Criteria Removes All Criteria Fields and Tables =

Article ID: 193480

Article Last Modified on 9/25/2001

-

APPLIES TO


 * Microsoft Office 97 Standard Edition
 * Microsoft Query 2000

-



This article was previously published under Q193480





SYMPTOMS
When you add criteria to the criteria pane in Microsoft Query and undo your last action by clicking Undo on the Edit menu (or Ctrl+Z), all of the fields in the criteria pane are removed and all of the tables are removed from your query.



CAUSE
This problem occurs when all of the following are true:


 * You do not have the Automatic Query set to On. -and-


 * You click Undo on the Edit menu.



WORKAROUND
To work around this problem, set the Automatic Query feature to On before you attempt to undo any actions in the criteria pane. To turn on the Automatic Query feature, click the Auto Query button or on the Records menu, click Automatic Query. Note that when this feature is enabled, the Auto Query button will appear pressed and the Automatic Query command on the Records menu will appear with a check mark.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Query 97 for Windows.



MORE INFORMATION
In Microsoft Query, there are several ways you can retrieve external data. When you want to create a simple query or criteria for creating a more complex query, you can use the Query Wizard. A criteria is a method of filtering the data by specifying values to match records within certain fields. Microsoft Query allows you to view the result set in its data pane. When you are sure the result set contains the data you want, you can return it to Microsoft Excel.

