Results 1 to 2 of 2
  1. #1
    jordanturner is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Sep 2010
    Location
    Burnley, England
    Posts
    32

    Access 2010 Sub forms

    Hi,

    I have recently upgraded to Access 2010 and I am liking a lot of the changes. I am having problems with a sub form that appears on a purchase order form. The problem I am having is I cannot get the fields to list in the right order. In 2007 the fields seemed to lock to each other in design view. If the ItemName field was at the top of the list, then it would be the first displayed on the sub form in form view. Suddenly in 2010 the field do not lock into each other and they seem to appear in a random order in the form view. You can edit the positions in form view and position the fields, but when you close the form and open it again, the positions are not saved (even if you save the form).

    Any ideas would be very helpful

    Thanks in advance

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Is your SubForm bound to a query with an OrderBy clause? It should be to get the results you desire. Is the SubForm in Continuous form view or Datasheet view?

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

Similar Threads

  1. Access 2010
    By Desstro in forum Access
    Replies: 8
    Last Post: 01-19-2016, 04:09 PM
  2. Feedback for Access 2010
    By Michele Keck in forum Access
    Replies: 1
    Last Post: 10-01-2010, 11:47 AM
  3. Replies: 1
    Last Post: 09-26-2010, 04:17 PM
  4. SharePoint and Access 2010
    By ksmith in forum SharePoint
    Replies: 4
    Last Post: 08-24-2010, 09:19 AM
  5. MS Access 2007 vs 2010
    By ralphjramirez in forum Access
    Replies: 2
    Last Post: 05-06-2010, 06:30 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