DLOOKUP MESS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top