Results 1 to 2 of 2
  1. 07-15-2010, 02:08 PM #1
    ksmithson
    ksmithson is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    Posts
    7

    Validation Question

    I am trying to validate data that when the user goes to the form and goes from report #1 to report #2 is there are any nulls from report #1 it will not let them move on. Before and After Update requires that data has to be chnaged, right? What can I do to force validation if no data was entered and the report was skipped completely?
    Reply With Quote Reply With Quote
  2. 07-15-2010, 03:02 PM #2
    TheShabz
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    make them required fields in the table design. that will not only prevent them from leaving report 1, but will prevent a bad entry into your tables.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Validation rules question
    By cps6568 in forum Access
    Replies: 3
    Last Post: 01-12-2010, 02:01 PM
  2. Validation Rule
    By smitstev in forum Access
    Replies: 5
    Last Post: 06-30-2009, 09:58 AM
  3. Validation problems...
    By dbDamo in forum Forms
    Replies: 1
    Last Post: 05-15-2009, 12:43 PM
  4. Validation on identical text question
    By edrahl in forum Database Design
    Replies: 1
    Last Post: 02-26-2008, 09:38 AM
  5. Validation on import
    By andy_42 in forum Import/Export Data
    Replies: 1
    Last Post: 10-23-2006, 03:52 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums