Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Filter By Form on Subforms 1
- Thread starter Hendy
- Start date
-
1
- #2
SockMonkey
IS-IT--Management
The built in ACCESS Filter by Form does not work on the Subform.
I have been able to accomplish this with a separate unbound search form called from the main form.
With some coding you can set the search form to search both a main form as well as a subform.
The trick is creating some SQL that is called when you search any of the sub form fields. Then the SQL is applied to the record source and then if you have any fields from the main fomr that you included in the search a filter is applied to the main form.
I have been able to accomplish this with a separate unbound search form called from the main form.
With some coding you can set the search form to search both a main form as well as a subform.
The trick is creating some SQL that is called when you search any of the sub form fields. Then the SQL is applied to the record source and then if you have any fields from the main fomr that you included in the search a filter is applied to the main form.
- Status
Similar threads
- Locked
- Question
