combo text in report

[Aidanb]

Hi All,

I have a form that i want to print in to a report. i have set the report up and it works ok i am just having trouble with a look up field in the table that will only produce the value not the associated text. the lookup field is a combo box on the form that pulls from another table it is linked through the table not through a querie in the form.

any ideas would be a help.

Regards

Aidan

 

[pbaldy]

If you mean a table level lookup field, I wouldn't use it:

http://www.mvps.org/access/lookupfields.htm

In any case, generally I'd expect a report to be based on a query that joined the main source table and the lookup table, enabling you to return the text value as part of the report's source.