Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2020
    Posts
    1

    filter a form using combo box

    I have created table & form. I want to filter a form using combo box.
    field name is test, values are a, b


    how can i do that?

  2. #2
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,566
    Hi

    In the Header of the Form create a ComboBox using the Wizard

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725
    I agree with Mike. Here's a youtube video on Filter using a Combobox showing the steps.
    There are several articles related to MS Access Forms etc ---Google/Bing with some keywords.

  4. #4
    Bullschmidt's Avatar
    Bullschmidt is offline Freelance DB Developer
    Windows 10 Office 365
    Join Date
    Mar 2020
    Location
    USA
    Posts
    64
    And here is another resource that could be helpful...

    Using a Combo Box to Find Records

    http://www.allenbrowne.com/ser-03.html

  5. #5
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    Are you using the combo box to filter down a multiitem or datasheet view of records -or- are you wanted to use the combo to jump to or navigate to a specific record?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 02-24-2018, 11:48 PM
  2. How to use combo box as a filter for a form?
    By hagamablabla in forum Forms
    Replies: 5
    Last Post: 07-26-2017, 12:21 PM
  3. Replies: 11
    Last Post: 09-03-2015, 11:12 AM
  4. Filter A Form With Combo Box
    By JeffG3209 in forum Forms
    Replies: 15
    Last Post: 05-27-2011, 09:04 PM
  5. Filter my form from combo box
    By Angate in forum Forms
    Replies: 3
    Last Post: 04-24-2010, 01:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums