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

    Unanswered: Cannot Goto next record

    Hi,

    I create a form in MS Access,

    I want to set the form cannot go to next record if one of the fields is still Null when I click the "right" arrow button (go to next record).

    Just stay in the same record.

    Can the form do that?
    Thanks.

  2. #2
    Join Date
    Sep 2005
    Location
    Utah
    Posts
    136
    If I'm understanding you correctly - you don't want the user to be able to move on and create another record until the record they're in is complete.

    If that's the case you can set the property to "Required" for each field in the record you want filled in. There's probably a more elaborate way with code and all, but this seems the easiest.

Posting Permissions

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