Read Only

[ekomsky via AccessMonster.com]

I'm using 2003. I button on a form that calls a query to generate a pivot
table. When a user exits the pivot it prompts to save. I set it read only
using code, it still saves the changes. I tried doing the same with marco,
no luck. I just want the changes not to be saved when the user exits.
The only thing that works is setting the attribute to Read only, but then
they can't change tables in the database so i can't use that. Any Ideas ?

 

[Pete D.]

Look up acSaveNo

 

[ekomsky via AccessMonster.com]

Look up acSaveNo

I'm using 2003. I button on a form that calls a query to generate a pivot
table. When a user exits the pivot it prompts to save. I set it read

[quoted text clipped - 5 lines]

they can't change tables in the database so i can't use that. Any Ideas
?

Tried it no luck