How To Apply Filter on Forms - MS Access

[@shadowsruss9106]

Thanks a bunch - your description was excellent

[@robvaughan1732]

Brilliant. Just what I needed. Very professionally explained. Thank you so much.

[@DigitalCatalog]

+Rob Vaughan Thanks for your comments.

[@elmertundag7225]

Really

[@techashfaq]

Thank you very so much! It was very helpful! Just what I needed!

[@SgtMarquis]

This only filters based off the last filter picked. @6:19 into video you had HP as the brand and computers for the cat. But Hp and Dell were both listed.Is there anyway to have them work together or can this just be done 1 or the other, or the other if one is trying multiple filters here?

[@ssdusd]

Wonderful 👏 thanks 😊

[@techashfaq]

Very Best Explanation

[@rocky54app]

Thanks, it helps a lot. I'm getting numbers instead of values, what that means please

[@DigitalCatalog]

Thanks for your feedback. Coming back to your question, plz clarify where are you getting the numbers

[@chattyuk]

Hi, in your example it's not possible to filter by both brand and category at the same time. What would be the easiest way to filter by both or even multiple comboboxes?

[@DigitalCatalog]

Hi Christopher, I will surely do a video on that as well. But as a reference, you can check the Reports screen on which multiple selection boxes are there to generate report based on date range and other field. The same mechanism shall be applied. To filter on form screen, you can have multiple check boxes and based on selection of check boxes, the combo box values shall be applied on query to fetch the records.

[@liliaiskhakova1506]

Thank you so much! It was very helpful! Just what I needed! :)

[@DigitalCatalog]

Thank you for your comments.

[@najibafghan7962]

Great video but if we want to print just these filtered records via a report.

[@kiranarana7274]

I have filter on form Datefrom en DateTo Wat wil be de filter on query [Forms]![frmData]! Between [Datefrom] and [DateTo] Please help

[@whittlero]

Clear explanation, thanks!

[@DigitalCatalog]

Thanks for your comments.

[@ramusingapore]

Excellent Video

[@DigitalCatalog]

+Nathan Srini Thanks for your comments.

[@abibshidi2629]

Hello, If I had a main form and also a subform similar to your example, is it possible to filter the sub form? I assume the Sql code would be different?

[@DigitalCatalog]

Hi. Yes it is possible. Will you plz explain the scenario so that I will be able to work on that. Apologies for much delayed response.

[@jomercasiano]

how to sort set filter field name depending selected on the checkbox?

[@hkiran3742]

How to apply filter like this in my order form like if i choose HP brand i should be able to get only hp product in product selection. In in orderItem Sub Form.Thank

[@DigitalCatalog]

Hi, there are mutiple ways to achieve this. You can change the recordsource of subform using VBA code on Click event of Apply Filter Button. The above example can be used to achieve your target. Let me know if you have any further query or you can send me your form to put the code there.

[@hkiran3742]

Thanks for reply sir I have create a simple GST Billing Database in access All three tax rate are in product table . Sir i want the OrderDetail sub form to update tax rate based on my Salestype combo box selection in main form like If SalesTypes= Local sales Than only SGSTRate and CGSTRate Else InterState Sales than only IGSTRate from product Table.

[@DigitalCatalog]

You can communicate with me at [e-mail] with screenshots of your tables and forms. I will try my best to provide you with the best possible solution.

[@pw.70]

This isn't technically a filter - you're changing the entire supply query for the form. A filter is applied using the Filter and FilterOn properties of the form.

[@BogusJesus]

What populates the combo boxes initially?

[@DigitalCatalog]

Hi Thomas, Apologies for late reply. The combo boxes are taking data directly from Master Tables at the form load. Let me know if you require further explanation.

[@riantoajiwaskito4446]

how if a parameter value is numeric? like filter date

[@DigitalCatalog]

Hi Waskito, I have added a new short video on how to apply filter by date and then reset it back to original records. You just need to put format "short date" for that field and then on the form having text box should also have "short date" format. Other details are there in the video. kzbin.info/www/bejne/q6rceXlrbMmlaK8

[@riantoajiwaskito4446]

i have watched the short video thats awesome but i still have syntax error with missing operator

[@mahmoodsheikh4046]

Hey sir how can I contact u .. email whatsaap or messenger ?