Phantom Queries

[PeterPfaffJCI]

I have created a data base in Access 2003 that when in the form object a
parameter quesry will run without any prompting. In looking at my design I
am having trouble finding anything that would trigger it. All of my queries
are activated by macros in the database project. Is there any place to look
to find the bug to fix this Phantom query?

Thanking you in advance for your thoughts on this matter.

Regards,

Pete Pfaff

 

[Jeff Boyce]

Pete

First, do any of your queries call for input/parameters? If so, one
approach might be to subtly change a query's name (e.g., prefix it with "z",
as in "zYourQuery") and rerun the form. Try this until the form breaks,
unable to find it's query.

Another possibility (although you didn't mention this), is that the form
formerly used a query and doesn't now. You might be able to run Compact &
Repair (after creating a backup, of course!) to resolve the problem.

There are other possibilities, but try starting with those...

Regards

Jeff Boyce
Microsoft Office/Access MVP