Sorry but something else just came up.
Once I select a filter and set it, it works fine. But once I clear it and it goes back to its unfiltered state the filter doesn't work a second time; I have to close and reopen it each time I try to change a filter....
User Profile
Collapse
-
I sincerely thank you. I've made so much progress and I appreciate the time you took to help me out....Leave a comment:
-
I changed the ORDER BY because instead of listing just several names I wanted, it listed the names everytime it appeared in the table. If Jose Noriega was a presented 10 times, his name appeared 10 times on my combo box when I just wanted it once...Leave a comment:
-
Holy cow, it works! I really have been trying to figure this out for nearly three days now; I'm so grateful. However the 'Clear Button' isn't working the way I want it to. I assumed that once I applied a filter then pressing this button would refresh the report to its original state without filters but all it does is clear the combo box. Any suggestions?...Leave a comment:
-
I just tried to learn this over the past two days so I'm not quite sure what you need. I already appreciate all that you're doing so if you can really decifer what the heck this all is then you will be my new super hero.
My Popup 'Presentation Filter' Form looks like this:
Presenter: (Filter1) rowsource:SELEC T Data.[Presenter's Name] FROM Data GROUP BY [Presenter's Name];
Evaluator: (Filter2) rowsource: SELECT...Leave a comment:
-
I have no idea..the message just says "enter parameter value". In ignorance I've just typed in random names and numbers to see what happens and of course, my report shows up blank...Leave a comment:
-
How to Filter a Report from a Pop-Up Form
I'm trying to create a popup form so that my peers have and easy way to filter information by 4 categories: Presenter, Evaluator, Date, or Topic. All this information is stored in my Data table and I have created a report called rptEvaluation. Seperately I have created a form with these Presenter, Evaluator, etc in a combo box. I have gotten as far as my pop up box coming up with the report and all the search options listed. I have also included...
No activity results to display
Show More
Leave a comment: