Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-01-2018, 03:09 AM   #1
JPFred
Newly Registered User
Silver Supporter
 
JPFred's Avatar
 
Join Date: Oct 2017
Location: Richmond, VA USA
Posts: 20
Thanks: 10
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.

Thanks,

Doc

__________________
Doc
JPFred is offline   Reply With Quote
Old 03-01-2018, 03:46 AM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 3,055
Thanks: 0
Thanked 669 Times in 654 Posts
Ranman256 will become famous soon enough 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
A S MANN
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)
Reply

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 10:48 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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