Filter by Form

[Tony Williams]

Sorry to repost but I cannot work this out. Can anyone come up with a
suggestion?
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?
TIA
Tony Williams
PS I'm a newbie with VBA so if that's the route simple steps would be
appreciated.

[Tom van Stiphout]

On Mon, 26 Apr 2004 16:38:25 +0000 (UTC), "Tony Williams"
<[e-mail]> wrote:

You found out the hard way that FbF is not very powerful.

The alternative is to realize that users rarely want to find by very
odd fields. That leaves a couple most-used fields, and you write your
own filter form for that.

-Tom.

Sorry to repost but I cannot work this out. Can anyone come up with a
suggestion?
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?
TIA
Tony Williams
PS I'm a newbie with VBA so if that's the route simple steps would be
appreciated.

[PC Datasheet]

Tony,

I can only generalize.

You aren't going to be able to simultaneously filter the main form and the
subforms at the same time because a specific main form record is associated with
a specific set of subform records. Subforms track main forms so you first need
to filter the main form which will bring with it the specific set of subform
records that are associated with the record in the main form. At that point, you
need to filter the set of subform records to get the specific record or records
you want.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


"Tony Williams" <[e-mail]> wrote in message
news:c6**********@sparta.btinternet.com...

Sorry to repost but I cannot work this out. Can anyone come up with a
suggestion?
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?
TIA
Tony Williams
PS I'm a newbie with VBA so if that's the route simple steps would be
appreciated.

[Tony Williams]

Thanks guys looks like back to square one and a rethink!!!
Tony
"Tony Williams" <[e-mail]> wrote in message
news:c6**********@sparta.btinternet.com...

Sorry to repost but I cannot work this out. Can anyone come up with a
suggestion?
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?
TIA
Tony Williams
PS I'm a newbie with VBA so if that's the route simple steps would be
appreciated.