Microsoft
AccessToGo!
A superb range of ready made databases and modules for use with Microsoft Access
Shopping
Home
View Cart (CheckOut)
Order Download
Contact Us
Databases To Go
Appointments Planner
Collections
Inventory of Assets Register
Membership Subscriptions and Donations
Simple Contacts Management
Contacts & Mail Merge
Contact Relationship Management
Simple Sales Orders
Simple Sales Inventory
Simple Purchase Orders
Service & Repair Management
Modules To Go
Report To PDF
Date Picker
Filter By Form
Media Player
Specialists in the design and build of robust Microsoft Access database solutions since 1992
i
Filter By Form

Filter any form that supports filters and for those with sub-forms, show its main records based on criteria entered for one or more of its sub-forms.

  • Global hot key will open our filter by form dialogue.

  • It automatically examines and binds itself to the current form.

  • Enter any criteria for the main form or any of its sub-forms.

  • Multiple sub-forms supported.

  • Nested sub-forms supported.

  • Toggle between ANDing and ORing multiple parameters.

  • No special OCX files are needed, completely native Access DAO and VB.

  • Re-usable code, include it in as many databases as you like!

  • You can easily change the format and colour scheme to suit your style.

The standard Microsoft filter by form simply reduces the displayed content of the sub-form and doesn’t do anything to the main form - not very useful.

AccessToGo filter by form reduces the records in the main form based on criteria entered in the sub-form - which is precisely what the user expects.

This download contains everything that you need to offer a Filter by Form dialogue by clicking a button on your form or implementing a global hot key. An example orders form and sub-form is included ready for you to use. A single function call opens the dialogue which will automatically build a compound filter and apply it to the current form.
Try it now FREE >>
Price Information >>
Buy It & Download Now >>
Feedback >>


So Simple to Implement:

  • Copy the dialogue form in to your database.
  • Copy the module in to your database.
  • Include a hot key in your Autokeys macro.
  • That’s it, you’re ready to go!
  • Full instructions and sample code included.
Click the picture to enlarge

Feedback: what other people said about Filter By Form

karla of United States says: "… outstanding! Filtering main forms base on data in subforms is soooo essential and, as you say, that’s what users expect …"

brian of United Kingdom says: "… I had this imported to my design within thirty minutes, took a while to go through and correct some of the bad naming in my forms but hey, I should have named the controls correctly in the first place :0) …"

timl of United States says: "… My developer was thoroughly impressed with what you built. Kudos! And thanks again, you have been extremely helpful with advice ..."

jake of United States said: "... easy to use. so far it's appears to be an improvement over the standard access filter. ..."

joek of United States said: "... filtering by form as it should be! nice job!! ..."

Robots Keywords: Filter, By, Form, Sieve, Strainer, Mesh, Riddle, Screen, Sifter, Sift, Sieve, Riddle, Clean, Clarify, Strain, Purify, Pass through a filter, Categorize, Categorise, Sift, Stream, Sort, Separate out, Divide up, Sort out, Trickle, Seep, Ooze, Permeate, Leak, Dribble, Penetrate, Percolate, Through, Thru, Via, In, By means of, Using, By way of, By dint of, As a result of, With, Near, Beside, Next to, Before, Not later than, Sooner than, Procedure, Method, System, Arrangement, Formula, Custom, Practice, Practise, Usage, Ritual, Shape, Appearance, Configuration, Outline, Structure, Look, Figure, Essentials, Characteristics, Outward appearance, Document, Paper, Questionnaire, Sheet, Blank, Table, Pro forma, Type, Variety, Kind, Mode, Manner, Style, Way, Start, Found, Create, Make, Establish, Develop, Bring into being, Develop, Materialize, Materialise, Arise, Grow, Take shape, Come into being, Fashion, Shape, Model, Create, Mould, Construct, Develop, Produce, fbf, apply filter, remove filter