Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    38

    Unanswered: How to sort a filter macro

    Hi,

    I have a form that shows one record at a time and there are over 900 records.

    Each record shows a project and one of the fileds is 'Status'.

    I have a few maros that can be selected on the form via a button and the macros filter by Status type, for example, if you select the In Progress button, the form now only shows the first record that is 'In progress' and selecting the next record takes you to the next In Progress record.

    Macro In Progress:

    InProgress - Applyfilter - [Status] = "In Progress"
    Show InProgress - ShowAllRecords

    Each Record has a "Last Updated Field". How can I get the filtered records to order by this field?

    Thanks Nige

  2. #2
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183

    How to sort a filter macro

    This may not be the exact solution for your issue, but if you would like to approach your problem then the links are given below:

    LEARN MS-ACCESS TIPS AND TRICKS - Filter Function output in ListBox
    LEARN MS-ACCESS TIPS AND TRICKS - Filter Function Output In Listbox-2
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

Posting Permissions

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