Access: Form w/table as Source Filter

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
2,332
Office Version
  1. 365
Platform
  1. Windows
When I have a Form based on a query, I am able to filter based on a Combo Box (Use the Combo selection as Criteria in Query).

If you have a Form with its source being a Table, is there a way to filter the data? I only want to see records where [Status] is "Active"
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Not that I know of (at least not easily), which is why it is always best to use a Query for the source of your Form. Even if initially, you aren't filtering anything or doing any calculations, it is always best to create a Query that returns all the fields to use as the source of your Form. then you can easily edit/change it simply by editing your query.

Note that even if you have already created the Form based on the Table, it should be pretty easy to change it. Just create a new query, add all the fields from the table, then go to the Form, open the Properties, and change the "Record Source" property of the Form from the table to the query you just created. All the fields should have the same name, so you shouldn't need to change anything else on the Form to get it to work.
 
Upvote 0
Why can't you use the filter

Code:
Me.Filter = "Client Like ""*" & Me.txtFilter & "*"""
Me.FilterOn = True

Do you do any research before you post here. Google even?
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,496
Messages
6,113,993
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top