INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Talk To Other MembersRegister now while it's still free!
Already a member? Close this window and log in.
RE: Filter By Form on Subforms
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.