Results 1 to 6 of 6

Thread: auto filter

  1. #1
    Join Date
    May 2004
    Posts
    17

    Unanswered: auto filter

    What I really trying to do is automatically filter records when the form is opened. Any help?

  2. #2
    Join Date
    Feb 2004
    Posts
    126
    What criteria are you trying to filter on?

  3. #3
    Join Date
    May 2004
    Posts
    17
    The form has a combo box. The criteria is based on particular data in this combo box.

  4. #4
    Join Date
    Feb 2004
    Posts
    126
    Are you asking how to filter the form in general, or how to get it to be filtered when the form opens? If it is when it opens what default value are you trying to display?

  5. #5
    Join Date
    May 2004
    Posts
    17
    I am trying to get it filtered when the form opens. Basically, I have a combo box called Status. The data for that box is either open or complete. I only want to show the records that have a status of open.

  6. #6
    Join Date
    Feb 2004
    Posts
    126
    Okay cool, that makes sense.

    Probably the easiest is to set the filter property for the form in its property box (also set the filteron property to true) and then in the combobox's After_update event, set it again to reflect the selection in the combobox, something like Me.filter = cboStatus (I think that works).

    What goes into the filter property is the where clause of a query but without the word where, something like:
    status = "open"

    Good Luck!

Posting Permissions

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