"DoDev" wrote in message
...
aI am trying to make modifications to the the SQL statement underlying a
subform. I make changes using the query builder. However, after I make
the
changes and save the updates my changes just disappear. This happens
regardless of what changes I make, e.g. I tried to add new columns, I
tried
to add new "where" criteria. After making the changes I close the builder
and
confirm that I do want to save the changes to the SQL statement.
Nevertheless my changes disappear.

Please help. I have been at it for hours.


Are you doing this in Access 2007? If so, there's a bug in the way the
property sheet works. After you close the builder and tell it to save your
changes, click on *some other line* in the property sheet -- so the focus
moves from the Record Source line -- and only then close the property sheet
and save the form.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)