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.
|
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
|
