M
mattc66 via AccessMonster.com
I have a main form that contains a button to print. This launches a second
form so that the user can select the qty of lables to print. The qty of
lables to print is written back to the orginal table of the main form.
After the user completes what they need on the second form and close it, they
are back on the main form with the same record. (The main form stayed open
during this process). When the go to the main form and go to create a new
record or close the one they are on, they are given a message that another
user has written data, do they want to save, discard changes?
What would be the best way to automatically save the changes for the user and
still take them back to the orginal form and record without giving them this
message?
I thought about closing the main form when the second form opens, then when
they close the second form, re-open the main form. I am wondering if there is
a better way.
Thanks
Matt
form so that the user can select the qty of lables to print. The qty of
lables to print is written back to the orginal table of the main form.
After the user completes what they need on the second form and close it, they
are back on the main form with the same record. (The main form stayed open
during this process). When the go to the main form and go to create a new
record or close the one they are on, they are given a message that another
user has written data, do they want to save, discard changes?
What would be the best way to automatically save the changes for the user and
still take them back to the orginal form and record without giving them this
message?
I thought about closing the main form when the second form opens, then when
they close the second form, re-open the main form. I am wondering if there is
a better way.
Thanks
Matt