Unanswered: Question: Updating the Filter on a Report
I'm still very much a new player in the Access/SQL ballgame and have been given an existing Access DB to fix some problems on. Here's one of the problems that I'm not sure how to fix though:
I have a report that pulls in user information. The query behind it pulls the matching records for all users, and the report filters on 'UserID = #', where # has to be entered manually each time to change the output. This requires the person who runs the report to have a master list printed out that shows UserID = Name so he can enter the right ID in the filter. There has to be a better way than this.
Is it possible to use the OnClick function on the report to bring up an unbound form with a drop down that shows all the actual names, have that unbound form get the UserID from the name, and have it update the report filter based on selection?
I hope this makes sense... I'm still rather new at this.
Easier method is to have a form, most likely either stand alone or launched by another form. Place a 2 column combo box containing customer id, and customer name (with column widths 0";1. Then in the filter, reference the form fields: forms!yourParameterForm!cust_id
Teddy, thanks for the suggestion, but I think I'm doing something wrong. I added an unbound form with a combo box that allows me to look through the names and select one, and it shows the appropriate UserID on the form, but when I try to run the report, it pops up with 'Enter Parameter Value' and doesn't filter any of the records at all.