I have a main form which has owner/operators listed in it. In my main form, I have several buttons with subforms, to add information to the owner/operator.
When I open the main form, search on a last name, and then click on a button to add the address or HR information, I have no problems. BUT, when I open my form, and make any changes to the main data (like update the phone number), and then try to search on another owner/operator (I have a button set up with a macro, to go to last name and then bring up search), I get an error, and then it forces me to close the form, and tells me that it can not save the data (even though it has saved the data). I have tried adding a "save" button to the main form, and when I click on that, a box pops open with nothing but an "OK" button to click, and I'm not sure if it's saving the form. I tried adding a "save and refresh" button, but again, if I make any changes to the data on the main form, and try to click button, I get an error (Error number 2950).
All I want to be able to do, is open the form, add or update the data on main form, and then have it "save" or "refresh" the data, so that the sub-data forms can be opened and updated as well, and all is good.
If this is confusing, it's confusing for me as well. I truly don't understand why the data is just not saving when I click the "save" button.
I have zipped the databases as that is the only way it would let me upload it to this.