dbTalk Databases Forums  

Toggle Form Edit button?

comp.database.ms-access comp.database.ms-access


Discuss Toggle Form Edit button? in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
LWD
 
Posts: n/a

Default Toggle Form Edit button? - 08-18-2003 , 10:11 PM






Hi, everyone

I'm wondering if anyone knows a relatively simple way to set up a button or
buttons to toggle allowing form editing on or off.

I want the user to be able to make this decision.

I know that I can go to design view and set "Allow Edits" on the property
palette - to 'no' but I'd like a macro to do this, then reset it to 'yes'.

Is there a relatively simple command that makes this possible?

Thanks in advance,

LWD



Reply With Quote
  #2  
Old   
Marc
 
Posts: n/a

Default Re: Toggle Form Edit button? - 08-23-2003 , 08:31 PM






hello LWD,

What about a switch-button with an after update-event procedure (VBA)
contauning a line like:

if Me.buttonname.Value = True Then Me.AllowEdits = True Else _
Me.AllowEdits = False

Marc

"LWD" <lucdix-NOSPAM (AT) NOSPAM-jam (DOT) rr.com> wrote

Quote:
Hi, everyone

I'm wondering if anyone knows a relatively simple way to set up a button or
buttons to toggle allowing form editing on or off.

I want the user to be able to make this decision.

I know that I can go to design view and set "Allow Edits" on the property
palette - to 'no' but I'd like a macro to do this, then reset it to 'yes'.

Is there a relatively simple command that makes this possible?

Thanks in advance,

LWD

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.