DLOOKUP MESS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sTEPHAN - 26 Oct 2005 18:25 GMT

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

Reply to this Message

Duane Hookom - 26 Oct 2005 18:43 GMT

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.

Signature

Duane Hookom
MS Access MVP

>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

Reply to this Message