Go Back   Access World Forums > Microsoft Access Discussion > Macros

Thread Tools Rate Thread Display Modes
Old 03-01-2018, 03:09 AM   #1
Newly Registered User
Silver Supporter
JPFred's Avatar
Join Date: Oct 2017
Location: Richmond, VA USA
Posts: 16
Thanks: 9
Thanked 0 Times in 0 Posts
JPFred is on a distinguished road
Question OpenForm (filter name)

I am fairly new to the macro creation utility in access and was wondering if anyone can give me a few examples with the use of "filter name". From what I can tell you can place a form or query name here to restrict record retrieval.



JPFred is offline   Reply With Quote
Old 03-01-2018, 03:46 AM   #2
Newly Registered User
Join Date: Apr 2015
Location: KY,USA
Posts: 2,928
Thanks: 0
Thanked 642 Times in 627 Posts
Ranman256 will become famous soon enough
Re: OpenForm (filter name)

less of a restriction, more of just a filter. Users can unfilter.
If you want to restrict, base the form on a query to the exact criteria, rather than filtering a query.
Ranman256 is offline   Reply With Quote
The Following User Says Thank You to Ranman256 For This Useful Post:
JPFred (03-01-2018)
Old 03-26-2018, 02:55 AM   #3
Newly Registered User
Join Date: Oct 2017
Posts: 9
Thanks: 0
Thanked 1 Time in 1 Post
A S MANN is on a distinguished road
Re: OpenForm (filter name)

Use the following as filter in condition part of query
=[Forms]![Form Name].[Filter Field name]
This will filter query to Form Name and shown Filter Field name.

A S MANN is offline   Reply With Quote
The Following User Says Thank You to A S MANN For This Useful Post:
JPFred (03-26-2018)

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
OpenForm Filter Novice1 Forms 1 07-22-2016 03:24 PM
Openform and filter the record Abg Forms 17 04-28-2010 08:09 AM
OpenForm changes Filter alexmb1 General 2 07-15-2009 05:32 AM
OpenForm filter Benjamin_Allen Forms 4 05-22-2006 12:05 PM
OpenForm Filter MartijnAn Forms 2 11-25-2005 04:48 AM

All times are GMT -8. The time now is 09:09 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World