Results 1 to 2 of 2
  1. #1
    durstlaw is offline Novice
    Windows 7 Access 2007
    Join Date
    Dec 2009
    Posts
    4

    Save and Go to another form - simple yes?

    Two forms, based on one table. In Access 2007 and Windows 7.



    I first filter form1 to one record. Then I want to navigate to form2. So I create a button on form1 called form2. Easy enough. OnClick, it shows form2, already filtered to that record.

    The problem is if I don't Save form1, and go to form2, then go back to form1, I get an error message saying someone is editing the record and I can't save.

    If I manually Save form1, then go to form2, then manually Save form2, and go back to form1, I don't seem to lose anything. But its silly to Save everytime. I knows there's simple code to insert on the button that goes to form2 that saves form1 before going to form2. I just don't know the code.

    http://allenbrowne.com/bug-01.html describes my problem, I think, but I can't make the solutions work.

    Any help would be sorely appreciated.

    John

  2. #2
    durstlaw is offline Novice
    Windows 7 Access 2007
    Join Date
    Dec 2009
    Posts
    4
    I figured it out: DoCmd.RunCommand acCmdSaveRecord, placed before the Close command. Duh.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Simple delete button on form
    By chessico in forum Forms
    Replies: 9
    Last Post: 10-15-2009, 03:14 PM
  2. Lookup Form (should be simple)
    By joshlee in forum Forms
    Replies: 3
    Last Post: 05-06-2009, 12:04 PM
  3. Simple Nav Form Code Not Working
    By alsoto in forum Forms
    Replies: 10
    Last Post: 04-10-2009, 09:30 AM
  4. Replies: 4
    Last Post: 04-01-2009, 11:48 AM
  5. Form requesting to save changes
    By stevo2820 in forum Forms
    Replies: 0
    Last Post: 07-30-2007, 07:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums