View Single Post
  #1  
Old August 4th, 2004, 05:17 PM
Jeff J
external usenet poster
 
Posts: n/a
Default "Corrupted" query

Using Access from Office XP I have written a query as part of a Query by Form operation. I have an unbound form with 7 text boxes and the query has 7 "columns" corresponding to those. The criteria on each column is in the form of two "rows" similar to the following:

First row
Like "*" & [Forms]![frmFilterDialog]![FirstName] & "*"

Second row
[Forms]![frmFilterDialog]![FirstName] Is Null

When I close and save the query in design view, then immediately re-open it in design view the criteria are "scattered" into dozens of rows of parts of the second row above. Even new columns are added with fragments of the second statement above as the field name. The first row above is not effected. I have tried creating a new database and a new query but the same thing happens. I have applied Office service pack 3. Any ideas?
Thanks