Hi,

I have a report based on a table which contains two combos. In the table both combos display text rather than a value but when I created a report one displays text and the other a value. The one that displays a value I have used to group the rest of the records by. What am I doing wrong please?

Most experts, myself included, would discourage the use of lookups defined in tables. They are a crutch for users who don't understand how to create a query but they cause much confusion once you get to the point of creating queries, writing VBA, and doing more advanced things.

The report that works is probably using a combo control. In order to see the "text" value for your lookups, it is best to create a query that joins the main table to the lookup table. That way you can select fields from both tables.

Thanks Pat for your suggestions.

I joined the two tables in a query and hey presto it worked perfectly.

Thanks again.