Results 1 to 2 of 2
  1. #1
    phd4212 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Posts
    4

    Error Checking within Form

    Hi All,



    I do not know if this is possible, but I want to create a separate text box that refers to an entry in the current form to validate the text (not a validate rule though). For example: If someone enters the purchase price as $1000 and the resale price of $2400, I'd want there to be a box next to the resale price that says "recheck resale value"

    Let me know if there is additional information you all need

    Thanks!

  2. #2
    TG_W is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Manvel, TX
    Posts
    299
    You can do it using If...Then statements that kick off after a field is updated using AfterUpdate.

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

Similar Threads

  1. Replies: 0
    Last Post: 03-06-2012, 11:55 PM
  2. Error 0 problem with error checking
    By SemiAuto40 in forum Programming
    Replies: 4
    Last Post: 12-07-2011, 12:21 PM
  3. Error checking field, SetFocus does not work
    By SemiAuto40 in forum Access
    Replies: 9
    Last Post: 07-26-2011, 10:08 AM
  4. Error Checking my Entry Result
    By AKQTS in forum Programming
    Replies: 3
    Last Post: 04-21-2011, 07:46 AM
  5. Date error checking
    By oediaz in forum Programming
    Replies: 2
    Last Post: 03-26-2010, 12:08 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
  •  
Other Forums: Microsoft Office Forums