Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I pin a custom text filter to a form?

Status
Not open for further replies.

NeilT123

Technical User
Jan 6, 2005
302
GB
Using Access 2007 with the ribbon closed.

I have a continuous form which if I right click in one of the fields I get an option for "Text Filter" and one of the sub options is "contains".
If I click on "contains" I get a small pop up window which I enter a value into and it filters the records on my form.

For me this is really useful but I would like to have something similar as a permanent feature on the form.

Can anyone suggest how I can achieve this?

Thanks

Neil
 

Perhaps...
Change the form's record source to include the filter. Something like...
Code:
WHERE [i]TextField[/i] LIKE *[i]value[/i]*


Randy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top