Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    300

    Question Unanswered: Bizarre Problem with Current Record

    When I open a form and show all records, it is supposed to go to the FIRST record in the table.. Instead, it picks another record in the middle of the table.. always the same one..

    I want it to show the first record like the rest.

    Any ideas??

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Access will typically return records in the order of the indexes of the table. If you have a primary key then it would in that order. Otherwise it would be by any other indexes you have. To force the order in which the records appear, base the form on a query that determines the sort order.

  3. #3
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    Open your form in designview and select the form properties and see if there is anything in 'Order By'. You can select your sort order here rather than creating a separate query.

    TD

  4. #4
    Join Date
    Nov 2003
    Posts
    300
    Thanks--buckeye_td !!

    That was exactly what was needed, it works great.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •