Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Cannot go to next record or exit if there is missing value

    Hi,

    In MS Access, Form

    I want to set up that if there is missing value of the fields, then we cannot go to next record or exit the form when we click to do next action.

    I tried to add the code in the After update event, or Exit event,

    Example Code:
    if (isnull([Zip]) or len([zip]) = 0) then
    msgbox "missing"
    [zip].setforce
    end if

    when I click to go to next record, or exit the form,
    it give out message "missing", it work fines,
    but, it still go to next record, or exit the form after the message.

    How do I fix it? Thanks.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    reading the help system 'ud be a pretty fine start.....

Posting Permissions

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