E
ekomsky via AccessMonster.com
Hello, I've researched this for a while and can't seem to find a solution to
the problem. I have a pivot that gets fed from a form, the form is tied to
a query. I tried doing this with queries and queries in forms.
So basically what i want is to have the users go into my pivots change
them, but when they exit i want the pivot to go back to the way i designed it.
Without asking to Save or not. I tried every way i could think of to do
this. It only works when i make an MDE file. Other wise the changes to the
pivot are permanent. I set it to open Read Only, but then it still asks to
save. I tried using acSaveNo and nothing happens. The changes are always
saved. I don't care if i have to use a query or a form to do this. I just
need a way to lock the pivot design. Me.undo didn't do anything. Maybe i
placed it in the wrong event.
Does any one have any Ideas this has been anoying me for a while. Thanks
in advance.
the problem. I have a pivot that gets fed from a form, the form is tied to
a query. I tried doing this with queries and queries in forms.
So basically what i want is to have the users go into my pivots change
them, but when they exit i want the pivot to go back to the way i designed it.
Without asking to Save or not. I tried every way i could think of to do
this. It only works when i make an MDE file. Other wise the changes to the
pivot are permanent. I set it to open Read Only, but then it still asks to
save. I tried using acSaveNo and nothing happens. The changes are always
saved. I don't care if i have to use a query or a form to do this. I just
need a way to lock the pivot design. Me.undo didn't do anything. Maybe i
placed it in the wrong event.
Does any one have any Ideas this has been anoying me for a while. Thanks
in advance.