Results 1 to 2 of 2
  1. #1
    ppiper is offline Novice
    Windows XP Access 97
    Join Date
    Dec 2010
    Posts
    7

    New user question

    Hi How do I get my form to do this (Originally asked in programming)
    In my table I have a column named Local the entree can only be Yes or No, If Yes is chosen then Column named County can only Be Nul eg;

    if[Column local]="yes" then [Column County] ="Nul"



    Can I, and how do I code this.
    Any help welcome.
    Thanks
    Peter

  2. #2
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,044
    Hi,

    If me.Local = true Then me.County = Null

    Tip: don't name a column Local, it's a reserved word in programming, so it could trigger errors.

    gr
    NG

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

Similar Threads

  1. New user with question
    By gabety in forum Access
    Replies: 9
    Last Post: 12-15-2010, 02:23 PM
  2. New user Question
    By ppiper in forum Programming
    Replies: 1
    Last Post: 12-01-2010, 11:53 AM
  3. New User with DAP Question
    By Tdo79 in forum Access
    Replies: 0
    Last Post: 11-14-2010, 07:37 PM
  4. Replies: 5
    Last Post: 08-05-2009, 12:13 PM
  5. User level security question
    By genesis in forum Security
    Replies: 1
    Last Post: 07-08-2009, 10:10 AM

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