[mso] Re: Access 2003 Checkboxes

I have handled similar situations by making the form itself update-able,
but disabling certain fields from edits, I sure don't have any neater
solutions, and haven't tried the method you mentioned, but it looks good,
especially if you've only got one field you're allowing.  In my case, it's
the opposite, most they can edit, but don't touch a couple!


                                                                                
                                               
                       "Green"                                                  
                                               
                       <1z@xxxxxxxxxxxxxx>                                      
                                               
                       Sent by:                                                 
                                            To 
                       mso-bounce@freelists.         <mso@xxxxxxxxxxxxx>        
                                               
                       org                                                      
                                            cc 
                       01/26/2007 07:05 AM                                      
                                               
                       Please respond to mso                                    
                                       Subject 
                                                     [mso] Re: Access 2003 
Checkboxes                                          
                                                                                
                                               
                                                                                
                                               
                                                                                
                                               
                                                                                
                                               
                                                                                
                                               
                                                                                
                                               
                                                                                
                                               


Yo Cathy,

I dunno what exactly but something in your message tinckled a bell.

I checked the form properties and Allow Edits was false.... Which is what I
want.. I don't want the user to alter data unless I let her.

So then how do I let her alter a check box??

It feels like bad practice but I put an allow edits = true in the checkbox
gotfocus event and an allow edits = false in the lostfocus event.

Does anyone have a neater solution??

TIA
Lisa

And many thanks Cathy!!

> Is it unbound or tied to a recordsource, and is there any
> code on the click
> event or is it simply capturing data back to the table?
> Thanks, Cathy






-----------------------------------------------------------------------------------------------------
The information transmitted is intended only for the person
or entity to which it is addressed and may contain proprietary,  
business-confidential and/or privileged material.
If you are not the intended recipient of this message you 
are hereby notified that any use, review, retransmission, 
dissemination, distribution, reproduction or any action taken
in reliance upon this message is prohibited. If you received
this in error, please contact the sender and delete the 
material from any computer.  Any views expressed in this message
are those of the individual sender and may not necessarily reflect 
the views of the company.  
-------------------------------------------------------------------------------------------------------

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: