Saving Form/Report Alters my Query

[Kevin]

I am seeking help on a problem that I have experienced. I
posted earlier today, to no avail.

I have created a query that obtains its criteria through a
form. However, this query is being changed whenever I
save any other objects in my database. I can make minor
formatting changes to a report or form, and as a result,
my query is altered. Specifically, the first field in the
query is being duplicated in place of any other fields
that I had previously defined. Has anyone ever seen this
occur?

Thanks in advance for any assistance!

 

[Eric Butts]

Hi,

That's weird!!! Are you able to repro this in the Northwind database
sample? If not, then you maybe experiencing database corruption. Try
importing your objects into a new database file.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."