List names in Report

[Javen]

Hi There, I know this may not seem difficult, but it's driving me crazy. I have a report based on a query. There's a field in the form that uses a lookup wizard which grabs a list from another table (a list of names)



When I created and ran the query it displays the names. But when I run the report based on that query, it shows a number instead of the name.

Thanks for your help... Javen

[alansidman]

You probably have a another table that is linked to the table which contains the number. The number is the foreign key which is joined to the primary key in the separate(lookup) table. You will need to add the second table to your report to get the names. Look at your query in design view to see the join and table name and fields.

Alan

[June7]

Would have to use a combo or list box with a RowSource for the lookup name value to show, just like on the form. Combo and list boxes are of no use on a report in Print Preview and probably not good idea to have bound combo or list box on a report.

So for the report, do as alansidman is suggesting. The report RecordSource must be a join of the tables and then pull the name field into the query. Be sure to get the jointype correct.

[Javen]

Thanks Guys,
Problem solved