Results 1 to 2 of 2
  1. #1
    Join Date
    May 2013
    Posts
    1

    Help Wanted..

    First off hello to everyone..



    Allow me to explain the problem I am facing... I am designing this database for my mother's church, they want to be able to enter the member personal information. Now I would like to set it so for instance if they say someone is single, the date of marriage field would not accept any data... I figure i would use a validation rule for that but how would i word the rule..

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    I'd probably use the before update event of the form:

    http://www.baldyweb.com/BeforeUpdate.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Help wanted in SW Wisconsin
    By ldodge in forum Access
    Replies: 0
    Last Post: 06-30-2011, 06:21 AM
  2. a bar on the side not wanted
    By techexpressinc in forum Forms
    Replies: 4
    Last Post: 06-28-2011, 07:49 AM
  3. Crosstab Query Help Wanted
    By goodguy in forum Queries
    Replies: 19
    Last Post: 12-30-2010, 10:29 AM
  4. Programmer Wanted
    By Hoota Caroota in forum Access
    Replies: 2
    Last Post: 11-15-2010, 08:56 PM
  5. 90 days in the pass - Date help wanted
    By techexpressinc in forum Queries
    Replies: 1
    Last Post: 01-26-2009, 07:13 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