Filter on specific parameter

juneau730

Board Regular
Joined
Jun 7, 2018
Messages
80
Hello all,

Need a little bit of assistance.

Is there a means to apply a filter parameter to a form, allowing it to only display specific data from the table?

Example, I have a table named Joe's Pool Hall, that lists the patron's, but for all three pool hall locations. I want the form view to only display those from location 1.

I currently do not have a query built for this, because in my instance, the raw data is imported directing into the table and shown on the form. I know I can build a query for this, but if I can filter the form, it would be a quicker fix, as this need to be applied for multiple folks.
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

JonXL

Active Member
Joined
Feb 5, 2018
Messages
326
Office Version
365, 2016
Platform
Windows
Do you want to do this in VBA? Do you need the usual parameter prompt to come up when the form opens so the users can enter the location or are you just setting the same location value for everyone as default?
 

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,628
Office Version
2013
Platform
Windows
In Access if you right-click on a field you can filter by the field. There is also a filter menu item. Seems like nobody likes to use it but it is effective and already built in and personally I use find it effective in many situations.
 

juneau730

Board Regular
Joined
Jun 7, 2018
Messages
80
Thanks for the replied.
I was able to work this out using additional parameters in the queries already created in the dBase and achieve the needed results. The users are happy, so I am happy.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,727
Messages
5,446,166
Members
405,388
Latest member
Arlind

This Week's Hot Topics

Top