Results 1 to 3 of 3
  1. #1
    Bradex is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Posts
    101

    Enforce sequential data entry

    I have a form with 10 fields. All of them are mandatory (Required = yes).
    I want the user to enter the fields sequentially. I would not like them to skip a field to enter another.


    How can I do this?

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Assuming that you have a valid business reason for wanting to do this (end users really, really hate being told how to fill a Form in!)...In the Form_Current event:

    • Disable all Controls except the first one to be populated
    • In the AfterUpdate event of the first Control, if it isn't Null (empty), Enable the second Control
    • And so forth...for each Control, in turn

    Linq Adams ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Bradex is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Posts
    101
    Hmm... I agree with you... Even I felt irked while filling up the form!

    Dropping this idea!

    Thanks for the solution as well!

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

Similar Threads

  1. Replies: 16
    Last Post: 04-21-2015, 04:52 PM
  2. Replies: 7
    Last Post: 03-05-2015, 07:34 AM
  3. How to enforce this?
    By vientito in forum Access
    Replies: 4
    Last Post: 10-23-2014, 01:48 PM
  4. Display only sequential query data?
    By Kylester in forum Queries
    Replies: 3
    Last Post: 11-08-2012, 07:45 PM
  5. Passing data to sequential form fields
    By jeepfamilyva in forum Forms
    Replies: 0
    Last Post: 06-28-2009, 11:04 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