I need help with getting the correct info into a report. I have a large table (MAIN table) with many fields. Each field is connected to another unique table through the use of a lookup menu. I have created a form to help with data entry into MAIN table. The form consists of mostly drop down menus. IN this way I can enter data by choosing off a menu.
The menu is composed of two colums- a code # column and a text statement column. The way the form is set up is that the code# is stored on the form.
Now I want to generate a report but would like the text statements , not the code # to appear on the report. How do I do this. Do I have to alter RowSource or Bound Column property or, is there a different answer. Thanks for any help.

Build a query that joins the main table to the various lookup tables. Use a left join to connect the tables unless the lookup fields are required. Then base the report on the query. You will have all the fields you need right in the report's recordsource.