Results 1 to 4 of 4
  1. #1
    cself is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2017
    Location
    Lousiana
    Posts
    5

    Sub-form tab sequence issue

    I have a sub-form within a data entry form. As you tab or index through the form the cursor goes to the second field (Amt)instead of the first (Designated Acct) in the sub-form forcing the user to hit the left arrow to get into the first field. The tab index is set correctly. The first data entry field in the sub-form (Designated Acct) uses a combo box to select the account name and the second is a text box for entering an amount.

    Thank you very much.

    Click image for larger version. 

Name:	Data Entry Form.jpg 
Views:	17 
Size:	220.1 KB 
ID:	32374

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    If your tab order is set correctly, then it could be that the Tab Stop property for the combobox is set to No.

  3. #3
    cself is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2017
    Location
    Lousiana
    Posts
    5
    Thanks, I checked and the Tab Stop is set to Yes.

  4. #4
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,421
    I think the subform itself shouldn't be in the tab order. However, if that's not it and you are 100% correct that the tab order is right (how would we know?) then you could always SetFocus on the required control in the subform if users are following a fairly regimented order of data entry on the main form. You could use the Exit event.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Form data out of sequence
    By khughes46 in forum Forms
    Replies: 4
    Last Post: 08-11-2015, 10:38 AM
  2. Form sort Sequence
    By jrmbach in forum Forms
    Replies: 1
    Last Post: 05-26-2014, 02:33 PM
  3. Sequence of data entry fields in a form
    By Academia in forum Forms
    Replies: 2
    Last Post: 08-01-2013, 08:06 AM
  4. Replies: 22
    Last Post: 05-21-2013, 07:54 PM
  5. how to get oracle sequence value at form
    By newaccess in forum Forms
    Replies: 5
    Last Post: 12-28-2012, 02:28 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