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.
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.
Comment