Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    10

    Question Unanswered: sorting form by ID

    does anyone know how to sort the form by ID #? I made a query before i made a new form and now its sorted by the query instead of the ID #

  2. #2
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346

    Re: sorting form by ID

    Modify your query to include the ORDER BY clause i.e.

    SELECT * FROM TABLE1 ORDER BY ID
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    In the form Open event writhe


    Me.OrderByOn = True

    Me.OrderBy = txt_ID


Posting Permissions

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