Results 1 to 2 of 2
  1. #1
    Rainman1960 is offline Novice
    Windows 7 Access 2007
    Join Date
    May 2010
    Posts
    1

    Forms


    Can I have a field in a database that has a validation rule iif>2 go to a re-order form

  2. #2
    evander is offline Competent Performer
    Windows 7 Access 2003
    Join Date
    Apr 2010
    Location
    Philippines
    Posts
    206
    Hello Rainman. Yes you can, but it's gonna take a bit of VBA programming. The idea is:
    a. Create the AfterUpdate event of the textbox.
    b. Create an IF statement inside the event.
    c. Create a DoCmd command inside the IF statement.

    Hope this helps.
    Good luck.

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

Similar Threads

  1. Replies: 4
    Last Post: 04-01-2009, 08:49 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