+ Reply to Thread
Results 1 to 2 of 2

Lock the field when the other is empty

  1. #1
    Registered User
    Join Date
    10-24-2019
    Location
    Londyn
    MS-Off Ver
    2016
    Posts
    2

    Lock the field when the other is empty

    Hi, I have a question if there is a way in my "TEST" form when the "Test2" text field is empty, block the possibility of entering data into the "NRB" subfolder. I tried to use the following code which doesn't work.

    Please Login or Register  to view this content.
    TEST.PNG
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Lock the field when the other is empty

    I do not code for Access but for Excel I would do something like this:

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 10-26-2019 at 05:26 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Checking a field for a value when the field might be empty
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-22-2017, 03:06 PM
  2. Lock one field in functional pivot tabla
    By abamg in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-03-2015, 10:39 AM
  3. [SOLVED] how to lock a field in excel?
    By Ir1e in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-28-2013, 12:20 PM
  4. Lock fields until one field has been filled in
    By ryback1972 in forum Excel General
    Replies: 11
    Last Post: 11-18-2012, 07:13 PM
  5. Automatically Lock non-empty cells two times per day
    By Vanrema in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2012, 07:08 PM
  6. Lock all non-empty cells
    By knab in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-24-2010, 09:33 AM
  7. Lock a field
    By KFC in forum Excel General
    Replies: 0
    Last Post: 01-19-2006, 04:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1