Dropdown to Find Records
I'm looking for assistance on how to use a dropdown box on a layout to find a recordset. The idea is the user would be able to select an item from a dropdown box, upon selection, the recordset would narrow to those matching records.
First, I just don't know how to do it. I tried my luck with a script tied to the OnModify action of the dropdown list. It looks like it tried to work as I get a message telling me no such records meet the criteria. One of the problems may be the ID field I am trying to use. I have a table of committees, and each committee has a unique identifier. Obviously, I would want to do the match on the Committee ID, but I need to populate the dropdown with the actual committee name (e.g. my users will have no idea what committee 14H is).
On the dropdown, can it include two fields, one hidden (e.g. the ID field). If so, how do I tell the script to match based on that hidden field?
I hope this makes sense. Thanks for any assist.