If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Modifying subform's underlying SQL statement
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 |
#2
|
|||
|
|||
Modifying subform's underlying SQL statement
"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) |
#3
|
|||
|
|||
Modifying subform's underlying SQL statement
Dirk,
Thank you very much. Your are right on. I am using Access 2007 and the workaround works like a champ. Thanks again. "Dirk Goldgar" wrote: "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) |
Thread Tools | |
Display Modes | |
|
|