showing all fields in combo box in a report

[ella]

help! i'd like all fields in my combo box to appear in my report. i've created a query from the table where my combo box is. i'd like all data about the general agent to appear i.e. GA number, GA last name, GA first name but what only appears is the GA last name. this would create a big problem if there are, for example, two GAs with the same last name in the future. i'm already going crazy. help! pleaseeee!

 

[Pat Hartman]

Create a query that joins the GA table to your main table and use that query as the recordsource for the report. Then you can choose whatever fields you need from the GA table to show on the report. If the report already is based on a query, delete it from the recordsource, save the report and put it back. This will force Access to refresh the report's fields collection so the new fields will show up in the list of available fields.