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