Disappearing queries

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Has anyone run into what seems like a bug in Access 2000
where under certain conditions, queries are initialized?
Everytime I leave the form that has a particular query
linked to a subform on it, when I come back I get the
error, Query must have at least one destination field.
When I look at the query in design mode, sure enough, it
is totally blank.

Has anyone run into this before and have a clue as to why
Access seems to want to initalize my query?

Thanks in advance for any help.
Pat
 
It may be related to the AutoCorrect feature. Go to the Database window,
click Tools | Options | General tab, and uncheck AutoCorrect option. That
option does all kinds of strange things to databases, and this may be one
more of the strange things it does.

Also be sure that you've installed all the latest patches. Office 2000 on
your PC should now be at SP3.
 
Everytime I leave the form that has a particular query
linked to a subform on it, when I come back I get the
error, Query must have at least one destination field.
Click to expand...

Is this just a SELECT query? or is it (perhaps unintentionally) an
Append or MakeTable query? The latter will give this error if you
don't have any field being updated. Of course they aren't suitable as
form rowsources either!
 
Back
Top