Results 1 to 2 of 2
  1. #1
    bauer1544 is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    8

    if statement doesnt turn off me.allowedits and me.allowdeletions

    Click image for larger version. 

Name:	Screenshot (9).jpg 
Views:	11 
Size:	106.2 KB 
ID:	42425 I have this if statement at the end here CheckLock() the lbllocked.visable portion of it works fine. lbllocked is set to visible no as the default. allow edits and allow deltions are both set to default yes but even if i make it default no and take the if statement out it still lets me perform edits and deletions. I have also tried default no and left the if statement and the lbllocked portion still works fine and the allow edits and allow deletions still wont come off of yes / true.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    In future, please post code as text between CODE tags. You can edit your post.

    chkLocked is field in form RecordSource?

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. vba for changing AllowEdits on all Forms
    By mainerain in forum Programming
    Replies: 4
    Last Post: 07-20-2023, 09:10 AM
  2. AllowEdits and Subforms
    By fret hack in forum Forms
    Replies: 2
    Last Post: 10-16-2017, 09:39 AM
  3. .allowEdits property
    By Lukael in forum Access
    Replies: 3
    Last Post: 11-23-2015, 12:49 AM
  4. Allowedits according to the record
    By lios1984 in forum Forms
    Replies: 4
    Last Post: 06-20-2012, 11:41 PM
  5. AllowEdits in Subform
    By Jackie in forum Forms
    Replies: 3
    Last Post: 03-02-2011, 10:51 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums