470,614 Members | 1,440 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

Using Filter by Form on Tab Controls

I have a main form based on Table1. The form has a tab control of three
pages. Each page has a subform based on a different table ie subform1 based
on Table2, subform2 based on Table3 and subform3 based on Table4. I want the
user to be able to use the Filter By Form facility in Access but this does
not work when trying to select controls on the main form AND the subforms in
the same filter. I have looked at Allen Browne's help screen on this (thanks
Allen for that pointer) but that seems to only cater with one control on the
sub forms whereas there could be say 1 control on the main form and say 2
controls on the subforms. The users do not yet have the ability to run
queries themselves so I wondered is there was a way to use the Filter in the
way I describe?
Tony Williams
PS I'm a newbie with VBA so if that's the route simple steps would be
Nov 12 '05 #1
0 1382

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Tony Williams | last post: by
3 posts views Thread by Tony Williams | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.