Results 1 to 5 of 5
  1. #1
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231

    Form data out of sequence

    I have a form displaying names (primary and only sort sequence in the query) and dates one of which is DOB, from which I calculate the age. The query displays the data as desired, name sequence. The form is displaying by Age and Name. How can this happen?

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Is there a value in the Order By property of the form?

  3. #3
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    I don't see an Order By property for the form.

  4. #4
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Open the form in design view.
    Click the "Property Sheet" button on the ribbon (design tab) or use Alt-enter
    Click the "Data" tab in the property sheet
    The Order By property is the 6th line down

  5. #5
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    Found it, cleared it, working fine. Thanks.

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

Similar Threads

  1. Replies: 22
    Last Post: 02-04-2015, 07:48 PM
  2. Form sort Sequence
    By jrmbach in forum Forms
    Replies: 1
    Last Post: 05-26-2014, 02:33 PM
  3. Sequence No in order
    By bronson_mech in forum Queries
    Replies: 21
    Last Post: 11-30-2013, 09:16 PM
  4. Sequence of data entry fields in a form
    By Academia in forum Forms
    Replies: 2
    Last Post: 08-01-2013, 08:06 AM
  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