Modifying subform's underlying SQL statement

[DoDev]

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.

DoDev

 

[Dirk Goldgar]

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.

 

[DoDev]

Dirk,
Thank you very much. Your are right on. I am using Access 2007 and the
workaround works like a champ. Thanks again.