Modifying subform's underlying SQL statement

[DoDev]

I am trying to make modifications to the SQL statement underlying a
subform. I make the changes using Access Query Builder view. However, after
I make the changes and save them 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 and hours.

DoDev

 

[Allen Browne]

Suggestions?

1. Ensure you have the latest service pack
Particularly if you are using Access 2007, there was a bug like this. Grab
the update from:
http://www.microsoft.com/downloads/...18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en
or for previous versions go to:
http://support.microsoft.com/sp

2. After you close the query window and return to the Properties box, click
another property. This will help ensure that the property you just set got
updated (even if you don't have the SPs.)

3. If you're still stuck, follow the recovery sequence here:
http://allenbrowne.com/recover.html

 

[DoDev]

Allen,
Thank you very much.

Suggestions?

1. Ensure you have the latest service pack
Particularly if you are using Access 2007, there was a bug like this. Grab
the update from:
http://www.microsoft.com/downloads/...18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en
or for previous versions go to:
http://support.microsoft.com/sp

2. After you close the query window and return to the Properties box, click
another property. This will help ensure that the property you just set got
updated (even if you don't have the SPs.)

3. If you're still stuck, follow the recovery sequence here:
http://allenbrowne.com/recover.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.




.