Read Only

  • Thread starter ekomsky via AccessMonster.com
  • Start date
E

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 ?
 
E

ekomsky via AccessMonster.com

Pete said:
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
Click to expand...
[quoted text clipped - 5 lines]
they can't change tables in the database so i can't use that. Any Ideas
?
Click to expand...
Click to expand...
Tried it no luck
 
Top