DLOOKUP MESS

[sTEPHAN]

I HAVE A FIELD IN A TABLE FOR MODELNUMBERS WHICH IS A LOOKUP FROM TABLE
MODELNUMBERS. IT LISTS THE CORRECT MODELNUMBER WHEN i REVIEW EACH RECORD ON
THE FORM. BUT WHEN I CREATE A REPORT, IT DISPLAYS THE ID # OF THE
MODELNUMBERS DATABASE. WILL DLOOKUP CONVERT THIS ID TO THE CORRESPONDING
TEXT? hOW. THANKS

 

[Duane Hookom]

STOP SHOUTING! Please use upper and lower case text so that your message is
much easier to read.
Then consider reading http://www.mvps.org/access/lookupfields.htm about the
evil of lookup fields.

To get the correct "text" in your report, add the table containing the text
into your report's record source.