multiple filters and combo boxes

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • favor08
    New Member
    • Jan 2007
    • 56

    #1

    multiple filters and combo boxes

    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.
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32669

    #2
    Check out this tutorial (Example Filtering on a Form.) then, if you still have questions, come back and ask them.
    Anything left after this should be detailed nitty-gritty.

    Comment

    Working...