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"?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
Filter combo box based on another unrelated combo box 1
Testing for required data entry in form fields. 6
Filter Combo Box Options based on other Combo Box Selection 1
Using a Combo Box for Filtering a Continous Form 1
Combo Box & Report Questions 22
Use two combo boxes to control a third 9
re run query using new combo box selection 2

Back
Top