+ Reply to Thread
Results 1 to 5 of 5

[Table] Make Field Required (Yes or No) Based on a value in another Field

  1. #1
    Registered User
    Join Date
    04-13-2021
    Location
    Syria
    MS-Off Ver
    Microsoft Office Home and Student 2021
    Posts
    81

    [Table] Make Field Required (Yes or No) Based on a value in another Field

    Hello,
    I have a table for customers Info and It contains 3 columns.
    1- Communication method (Whatsapp OR Instagram),
    2- The customer number,
    3- customer username.
    Table Q.png

    I want, if the method of communication is on WhatsApp, the number column must be required, and it is not possible to write anything in the username column.
    Otherwise If the method is To communicate on Instagram, the username column must be required, and nothing can be written in the number column.

    Is this possible guys?
    And I hope my question is clear and thank you very much in advance...
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,947

    Re: [Table] Make Field Required (Yes or No) Based on a value in another Field

    Sorry - I thought that this was an Excel post.
    Last edited by Bernie Deitrick; 09-19-2023 at 03:00 PM.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,890

    Re: [Table] Make Field Required (Yes or No) Based on a value in another Field

    First rule of Access DataBases is that you should never input data directly into tables. Users should never have access to the tables. All data entry should be done through a form that is bound to the table. In the form, you can then have VBA in place to allow for the requirements of your data entry. In the meantime, I have no time right now to work on a solution for you with those thoughts in mind. I will be back shortly with hopefully a workable solution.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Registered User
    Join Date
    04-13-2021
    Location
    Syria
    MS-Off Ver
    Microsoft Office Home and Student 2021
    Posts
    81

    Re: [Table] Make Field Required (Yes or No) Based on a value in another Field

    Quote Originally Posted by Bernie Deitrick View Post
    Sorry - I thought that this was an Excel post.
    No, they are Access tables that I am trying to create to manage customer records, and of course I will later create queries and reports based on these tables.

  5. #5
    Registered User
    Join Date
    04-13-2021
    Location
    Syria
    MS-Off Ver
    Microsoft Office Home and Student 2021
    Posts
    81

    Re: [Table] Make Field Required (Yes or No) Based on a value in another Field

    Thank you very much @alansidman for this clarification.
    I thought i can achieve this validation in tables instead of forms .
    Anyway, thanks to point it out. Now I can research about this topic, hoping I can solve this problem myself...

+ 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. Replies: 6
    Last Post: 02-22-2023, 11:19 PM
  2. Pivot Table: Calculated Field based on Running Total Field
    By EvolvingMonkey in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-07-2016, 06:27 AM
  3. Replies: 0
    Last Post: 08-15-2016, 02:07 PM
  4. How do I make one field auto-enter a value based on another field?
    By Hippiechld in forum Access Tables & Databases
    Replies: 7
    Last Post: 01-08-2013, 11:08 PM
  5. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  6. Replies: 3
    Last Post: 03-03-2012, 12:16 PM
  7. In Excel, how to make a field required so it's not left blank?
    By linplex in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2006, 10:15 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