How to Filter a Report Based on the Filter Set in a Form in Microsoft Access

In this Microsoft Access tutorial I'm going to teach you how to filter a report based on the same filter and sort that you put in a form.

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

RECOMMENDED COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[dagnabbit]

Subscribed! This is EXACTLY the information I needed for a work project. Your videos are easy to follow. Thank you very, very much!

[josecandidosorianavalon]

Nice vide as all of yours, Richard! A single word coming from the old times when I worked with Access and VBA (You know, I am retired seven years ago). I used the With... End With when dealing with several objects of the same report or form... I mean: instead of repeating Me.Name, Me.Caption, etc., I used With Me .Name .Caption... End With. My twopences!

[cxp]

the filtering in datasheet view being able to select from a drop down list multiple items is very helpful in sorting. Can this button be added to form in datasheet view in order to preserve this sortability.

[monalikasaha]

Thank you for your great videos. When using Filters on Access, it displays actual Field Name instead of Captions. How can this be fixed? I dont want to change actual Field names into readable words with spaces

[eladborovsky]

Hi Richard. What if the data source of the filter is an SQL statement?

[kerrywsmyth]

This is valuable info. Will certainly be using this in all my Access DB's

[stevefaulkner]

Hi Richard. Steven Faulkner from Australia (working in Thailand) love your videos. I can make this work easily from a main form, but I have tried without success to do it from a subform databsheet (easier filtering options) but keep getting errors in the VBA code. I can do it if I use a split form, but they're a bit of a pain. Is there a way to do this from the subform?

[samisamuel]

Thanks really helped me with your lesson, regards

[lionen]

Hi Richard. I have a question, I have a yes/no field in the form and I want to issue a command to change all filtered fields to yes, I have a query where I entered the criteria but I want it to be done based on the filtered fields in the form. Can you help me?

[christiandecena]

Shout out to Alex for shouting to you and correcting your habit. That made me laugh!

[Shadow.Dragon]

Great video Richard! I'm always trying to figure out how to make my code as "efficient" (i.e. less lines) as possible. 🙂

[kirstenhebert]

Great video--one question: I set every report up in my database this way, all worked beautifully, I walked away for two weeks and it stopped working! Now the reports respond to my filters, but not my sorts despite my OrderBy! Also, where I used to be able to sort reports with a right click, now that functionality is gone. I'm so confused--could this be the result of an update?

[michael]

I have tried this and it works but not on sub form any ideas i get message saying not supported. I can only assume i am not doing something quite right. Very helpful video thanks Richard

[deltapixels]

Richard may I ask an unrelated question if I may please? Seeing as you are a huge Trekkie fan have you ever thought about making you Database forms look like the console screens on the Enterprise?

[badmustunde]

Good evening sir, your tutorial lessons are awesome, but I want to request for how to create student report card especially for a whole school with three terms of exams, thanks

How can this form filtering method be used to define a query that can be used as the report's record source?

[Cap.Mohammed-Ali]

what is your office version please ..?!

[bluegrey]

I'm not able to open report after adding the 2nd line of code