Results 1 to 4 of 4
  1. #1
    jj1 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    128

    Move to next record it saves even partial info and allows to move next

    I have a form on which I have given scroll bars to move to next record when somebody fills on any of the field it generates new ID People Instead of filling entire info leave that record incomplete and move to next one. How can I make people all the information before they scroll to the next record.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Either make fields required in the table or use the before update event of the form:

    http://www.baldyweb.com/BeforeUpdate.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    jj1 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    128
    How should I make table required when on to next record and what should I put in before update event

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You don't make the table required, you make the appropriate fields required. Required is a property of each field.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Move next unless record is matching then skip
    By Ruegen in forum Programming
    Replies: 2
    Last Post: 09-03-2014, 07:26 AM
  2. Replies: 15
    Last Post: 07-09-2014, 09:42 AM
  3. How to move to next record in a select query
    By lawdy in forum Programming
    Replies: 3
    Last Post: 02-17-2014, 01:31 PM
  4. Replies: 19
    Last Post: 06-05-2012, 08:19 AM
  5. Duplicate field(s) and move to new record
    By cwatson62 in forum Queries
    Replies: 0
    Last Post: 04-05-2011, 10:31 AM

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