Filtering a Record Selector (Microsoft Access)

35 pts.
Tags:
Microsoft Access
VBA
I need help figuring out how to filter a combobox that serves as a record selector. I set up a box that provides clients name & need it to filter them by agents assigned to each customer once the filter is set but, i cant get it to filter out customers under other agents. I would prefer a response in Macros as i don't know VBA very well. I couldn't find any threads on this. To explain more in depth i have form-A where i select an agent then press button-A to open form-B with the agent selected on form-A as the filter. I currently have it so it will only open records though a combobox record selector that have that agent but it still shows all of the customers instead of filtering it down to just selectable customers. Let me know if you need any more information to help me answer this.


Software/Hardware used:
Microsoft access
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Post your code so far and we will take a look.

    133,740 pointsBadges:
    report
  • CharlieBrowne
    If you search the web with your question, you will get sites that may help you out with this issue. Here is one of them: https://support.office.com/en-us/article/Apply-a-filter-to-view-select-records-in-an-Access-database-2a493ded-e544-4144-9103-b9b1d1865147?ui=en-US&rs=en-US&ad=US&fromAR=1
    62,385 pointsBadges:
    report
  • mmorrison
    Sorry that came out wierd i tried posting pictures but here are the links instead:

    http://s33.postimg.org/khw3k2hhr/after_update_search_filter.png
    http://s33.postimg.org/rz5aza70v/on_click_form_A.png
    http://s33.postimg.org/85xskbj0v/on_load_form_B.png

    First one is the Search function in the after update on form B which filters to the client you choose on the combobox
    Second is on click to the desired agent from Form A to Display corresponding clients on Form B
    Third is on load on form B which applies the filter.
    Form A= My clients
    Form B=Client Look up
    Button A= Agent
    ClientID is the primary key on the table being filtered.
    The search combobox is named combo10.
    35 pointsBadges:
    report
  • mmorrison
    Charlie, that doesn't quite answer my question I building a database for people to use that aren't familiar with access. I am trying to automate this process so they don't need to know how to filter or have access to do that.
    35 pointsBadges:
    report
  • CharlieBrowne
    Sorry, I was hoping at least one of the sites had an example for you.
    62,385 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: