showing all fields in combo box in a report

ella

Registered User.
Local time
Today, 22:04
Joined
Feb 19, 2002
Messages
13
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!
 
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.
 

Users who are viewing this thread

Back
Top Bottom