Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / July 2007

Tip: Looking for answers? Try searching our database.

Apply Filter Help??

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Access Help - 20 Jul 2007 01:06 GMT
Hi all,
I have form with a sub form in a DataSheet view. What I would like to do is,
filter one field so only the data matching that field will display in the
subform (datasheet view) within the main form.  Is this possible?  So I will
have a drop down box on the main form and when I select this it should filter
the subfomr with the appropiate data.  Can anyone help?
Thanks
Allen Browne - 20 Jul 2007 02:49 GMT
If it's just the one combo on the main form, you can do that just by setting
the Link Master Fields property of your subform to the name of the combo,
and the Link Child Fields property to the matching subform field. No code
needed. (If nothing is selected in the combo, the subform will show
nothing.)

If you want to be able to filter your form by different fields, this might
help:
   Find as you type - Filter forms with each keystroke
at:
   http://allenbrowne.com/AppFindAsUType.html
The idea is that you choose a field to filter by (combo), and then enter a
value to match (text box), and it filters the form as you type. You don't
need to make any changes to the code to get it to work with your form: just
copy'n'paste, and set one property.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi all,
> I have form with a sub form in a DataSheet view. What I would like to do
[quoted text clipped - 6 lines]
> the subfomr with the appropiate data.  Can anyone help?
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.