Showing name in report, not ID associated with name

[sstasiak]

I have a report that has a few fields that are set by combo box selections(choices are from other tables) in my main form. When I open the report, I get the ID associated with the names. Now, I know that I need to have the number stored in the main table, and not the name...but how can I set the report so that the name shows up and not the number?

I don't know much about building queries, but I think that might be how to accomplish what I want.

 

[rainman89]

Use a Dlookup to find the name and set a txt box equal to that.

http://www.mvps.org/access/general/gen0018.htm

so the source of the txt box would be =dlookup(blah, blah, blah)

 

[boblarson]

Or easier still, include the name field in the query underlying your report and put that in the ID's place.