Bug in Query Builder if you close property sheet

[geneking]

We discovered that if you have the property sheet up for a report and
activate the query builder and then close the property sheet before you close
and save the changes you made in the query builder, all your changes are
lost. If you close the query builder first and then close the property sheet,
it is ok.

An annoying little problem until you see the work around.

Anybody know how to report bugs to MS on Access problems without paying a
support fee?

 

[Allen Browne]

There is a bug in Access 2007, such that if you open the query builder from
the property sheet and you don't move to a different property in the
property sheet, you lose the changes to the SQL statement (or you can even
crash Access.) It's annoying. There's no fix yet AFAIK. But once you know
about it, you develop the habit of pressing enter to move to a different
property and ensuring that one is applied.

Is that what you are referring to? I didn't quite follow, because when you
click the Build button (...) beside the RecordSource property on the
property sheet, the query builder is modal, i.e. you can't close the
property sheet while you still have the query designer window open.

 

[geneking]

Allen:

This might be part of the same problem. In response to your "I didn't quite
follow..." one of our users found that they could be in report, have the
properties open, start the query builder, but then close the properties
before the query builder was closed and the changes were lost. I am able to
duplicate this problem.

Here is the version I am using: Microsoft Office Access 2007
(12.0.4518.1014) MSO(12.0.6017.5000)

Gene