Solved

Filter form via dropdown menu

Posted on 2009-04-12
3
1,009 Views
Last Modified: 2013-11-28
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
Comment
Question by:Greekiwi
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
SimonThompson earned 500 total points
ID: 24124959
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
 

Author Comment

by:Greekiwi
ID: 24125052
Thanks Simon. Seems very simple now that I think about it. But that's the benefit of this site I guess.
0
 
LVL 3

Expert Comment

by:SimonThompson
ID: 24125057
lol, we all do it mate, your welcome
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now