Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243

    Unanswered: sorting continuous forms

    I have a continuous form.
    Every record has 4 fields.
    On top of my form (above each column) is a label.
    I want to sort the form depending on the label I have clicked.
    How can I do this ?

    Thanks in advance

  2. #2
    Join Date
    Dec 2002
    Posts
    60

    Re: sorting continuous forms

    Don't know if this is the easiest way but should work:

    In the click (double click) event of the label change the form's recordsource and requery:

    mySQL="SELECT * FROM tbl WHERE .... ORDER BY selectedfield"
    me.recordsource=mySQL
    me.requery

Posting Permissions

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