Reverse filter for combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several fields in a form. The recommended option field is a
calcuation that gives me a result of #1-#4. My end-user is to select the
type of reports available to them depending upon the recommended option so I
need that combo box to only show the option availalbe to them. The form is
continuous so I need it to change the options available each time the
end-user gets to a new record. Using an If statement becomes to lengthy and
gets truncated. Any suggestions please?

Recommended Option Report Type
1 A
1 B
2 A
2 B
2 C
3 A
3 C
 
I don't understand. Think you might need to repost with an example of what
you want to happen... for example... where does the user "select the type of
reports available to them"?
 
Back
Top