Report is displaying number from a list; not the value

[Guest]

Newbee
I Have a field that i created a list box from (Municipality) within a form.
I created a report using the wizard.
the report displays the number of the value and not the text I.E. "Palm Beach"

I have a table which is my main datasheet: INDEX.
I have a table called LIST with a column called MUNICIPALITY with 70 or so
towns.
I have a form labeled ASSIGNMENTS which i want to use as my home base to
input this form has a drop down list for the MUNICIPALITY.

I have a report that is based on partial data from the INDEX created with
the wizard

But the data that i enter using the drop down populates the LIST ROW NUMBER
i.e 54 and not the data of that cell i.e. Lake Worth

I used the expression builder control source
=[«Expr»]=[Index]![Municipality] DOES NOT WORK
[Index]![Municipality] «Expr» [Index]![Municipality] DOES NOT WORK

Any suggestion would be greatly appreciated because i am confused

 

[Allen Browne]

Create a query that uses both your main table and the list box's table.

You can now select fields from both tables to use in your report.
After you save the query, open the report in design view.
Open the Properties box (View menu.)
Making sure the title of the Properties box says Report (so you are not
looking at the properties of a text box), on the Data tab set the
RecordSource property to the name of your query.

If some records are null in this field, the report won't show those records
unless you double-click the line joining the 2 tables in the upper pane of
query design, and choose option 2 or 3.