Multiple filters and combo boxrs

[lilbit27]

I need help with a big project. I am struggle getting multiple option
buttons and filters to work together. They need to be able to filter a
subform.

My first set of option buttons work fine
all
past due
demand fax

and my combo boxes work fine
opid
prodcd
policy.

What I don't have working is the new set of option button that say
60 day
90 day
and multiple dollar amounts.

For the option buttons all, past due, and demand fax a different str
is ran and then i enter change the record source on the the opid,
prodcd, and policy combo boxes based on the option button that I just
mention.

Now I need to take it a step futher and say the can select to see all
their items and then filter to see items gtr than 60 days and then
select the opid, prodcd , and policy. or the could select all and then
a particular dollar amount from the dollar option.

Or the just want to see a paticular dollar amount and not click
anything else. I need help in figuring out how to cover every scenario

I need al the buttons to interact with each other.

the first option group is frame 95 and then the second is frame
148(this is the new one). and i set each option to a number and that
equals ittype (an unbound text box) so i am saying if ittype equals
this then do this. for frame 95 and the combobox.

Any help is greatly appreciated.

 

[Vivi]

I had same experiences one month ago.
If you want to use a form to open a report, please reference:
http://www.fontstuff.com/access/acctut19.htm
If you want to use a form to refresh a subform or form, please reference:
http://allenbrowne.com/ser-62.html
Good luck.

Vivi