I have several fields on a form that stores the ID for the field. I use my form to filter records and then generate the report from a button on the form so it is also filtered. How can I get the value instead of the ID to show on the report? I would like to keep the ID showing on the form and only have the value displayed on the report. Any help is appreciated.

It sounds like you want to want to base the report on a query that joins 2 tables together, enabling you to get the value associated with the ID.