Multiple Subform Filters

[jasn_78]

Ok guys what im after is if this is even possible and how would be the best i should go about doing the following.


What i am trying to do is I have a query that will have a datediff field as well as a up to 4 total values

so its qryCOMPARISON: DateDiff, Amount1, Amount2, Amount3, Amount4

i know so far it doesnt sound like a form question but the part i need help with is how is the best way for me to design a form where the user can choose up to 4 different filters off a subform. I dont particularly want 4 different subforms for the same option as it looks ugly. lol

any ideas would be great

Regards
Jason

 

[pbaldy]

The sample db in this FAQ demonstrates one way to dynamically filter a subform:

http://www.mdbmakers.com/forums/showthread.php?t=4895

 

[jasn_78]

paul thanks but what i really want i am trying to do is to use this for a comparison report so for e.g. in the first options i want to choose location 1 for date period x

then compare to another set of options e.g. location 2 for date period y

i want to be able to repeat this until the user hits an open report button.

 

[jasn_78]

Paul attached is a screen shot of the form this might give u a better idea of what im trying to achieve.