D
Duck
I have a database that contains a couple of forms that each have
embedded in a subform, Pivot Charts displaying sales, and product
returned data respectively. I have a command button on each with
which I want to display the other. The click event for each command
button contains simple code to open the other form by passing an
OpenArgs value, which is picked up by the Current event of the other
form so that the particular product displayed in the calling form is
automatically displayed in the called form.
My problem is that when I click the button it always works fine the
first time, but anytime after that, I get an error message saying:
"This record has been changed by another user since you started
editing it. If you save the record you will overwrite the changes the
other user made.", along with some other stuff. The error msg box
then provides three button choices Save Record, Copy To Clipboard,
Drop Changes. As this is a single user and very simple database
(.mdb) on a stand-alone laptop, I don't have a clue as to why I am
getting this error
embedded in a subform, Pivot Charts displaying sales, and product
returned data respectively. I have a command button on each with
which I want to display the other. The click event for each command
button contains simple code to open the other form by passing an
OpenArgs value, which is picked up by the Current event of the other
form so that the particular product displayed in the calling form is
automatically displayed in the called form.
My problem is that when I click the button it always works fine the
first time, but anytime after that, I get an error message saying:
"This record has been changed by another user since you started
editing it. If you save the record you will overwrite the changes the
other user made.", along with some other stuff. The error msg box
then provides three button choices Save Record, Copy To Clipboard,
Drop Changes. As this is a single user and very simple database
(.mdb) on a stand-alone laptop, I don't have a clue as to why I am
getting this error