Results 1 to 3 of 3

Thread: Access: Form w/table as Source Filter

  1. #1
    Board Regular gheyman's Avatar
    Join Date
    Nov 2005
    Location
    Orlando, FL USA
    Posts
    1,662
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Access: Form w/table as Source Filter

    When I have a Form based on a query, I am able to filter based on a Combo Box (Use the Combo selection as Criteria in Query).

    If you have a Form with its source being a Table, is there a way to filter the data? I only want to see records where [Status] is "Active"
    G Heyman
    Northrop Grumman - Laser Systems'
    Apopka, FL

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    51,032
    Post Thanks / Like
    Mentioned
    57 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Access: Form w/table as Source Filter

    Not that I know of (at least not easily), which is why it is always best to use a Query for the source of your Form. Even if initially, you aren't filtering anything or doing any calculations, it is always best to create a Query that returns all the fields to use as the source of your Form. then you can easily edit/change it simply by editing your query.

    Note that even if you have already created the Form based on the Table, it should be pretty easy to change it. Just create a new query, add all the fields from the table, then go to the Form, open the Properties, and change the "Record Source" property of the Form from the table to the query you just created. All the fields should have the same name, so you shouldn't need to change anything else on the Form to get it to work.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular
    Join Date
    May 2013
    Posts
    666
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access: Form w/table as Source Filter

    Why can't you use the filter

    Code:
    Me.Filter = "Client Like ""*" & Me.txtFilter & "*"""
    Me.FilterOn = True
    Do you do any research before you post here. Google even?
    Last edited by welshgasman; Oct 16th, 2019 at 05:46 PM.
    Office 2007
    Access novice. Sometimes trying to give something back

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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