Results 1 to 6 of 6

Thread: MS ACCESS "Save changes to the design of query"?

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Mar 2005
    Posts
    111

    MS ACCESS "Save changes to the design of query"?

    Hi

    Got a real head banger case here!

    I have one subform with a query as it's source object on a main form. When I open and close the main form without making any changes, Access still asks me:

    "Do you want to save changes to the design of query 'qryFinalAmendments'?"

    A command button on the main form is clicked and the event has the following code:

    VB Code:
    1. Private Sub cmdCloseAmendments_Click()
    2. On Error GoTo Err_cmdCloseAmendments_Click
    3.    
    4.     DoCmd.Close acForm, "frmAmendments", acSaveNo
    5.    
    6.     DoCmd.OpenForm "Switchboard", acNormal
    7.  
    8. Exit_cmdCloseAmendments_Click:
    9.     Exit Sub
    10.  
    11.  
    12. Err_cmdCloseAmendments_Click:
    13.     MsgBox Err.Description
    14.     Resume Exit_cmdCloseAmendments_Click
    15.    
    16. End Sub


    The Form close event has no code. Can anyone tell me why I would be getting this message asking me if I would like to save changes that have not been made?

    Is there a way that I can stop this message appearing - I have already tried using "DoCmd.SetWarnings False" but this doesn't stop the message being displayed?


    Thanks

    Pobo
    Last edited by Pobo; Apr 25th, 2006 at 12:35 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width