Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1063
  • Last Modified:

Filter form via dropdown menu

I have a form (well a series of forms but I will start with just one) that contains records. One of the fields of the records is a status one. The actual field is based off its own table. What I want to do is have a dropdown menu in the header of the form (a multirecord form) that will filter it based on the selection in the drop down menu. An option to clear the filter would be nice as well.

I know that I can do this from the controls in Access but I would really like this functionality so the end user for the database has that option.
0
Greekiwi
Asked:
Greekiwi
  • 2
1 Solution
 
SimonThompsonCommented:
on change event of the combo box

me.filter="Status=" & me.MyCombo
me.filteron = true

and create a button to clear, and in onclick do this

me.filteron = false
0
 
GreekiwiAuthor Commented:
Thanks Simon. Seems very simple now that I think about it. But that's the benefit of this site I guess.
0
 
SimonThompsonCommented:
lol, we all do it mate, your welcome
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now