Avatar of shart68
shart68

asked on 

Report showing ID value rather than value in the query

I have a report that works off of a filtered query.  Everything works correctly on the report except a field shows the ID value rather than the value of the record.  The query that brings the data in shows the correct value in the field.  How do I fix?

Example in the report:
doc number       description     rev    type    
123                   test doc           A        1     (type should be Instructions)

thanks.
Microsoft Access

Avatar of undefined
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

This this Field in the Table the query is based on look something like the image below ?

mx
Capture1.gif
Avatar of Flyster
Flyster
Flag of United States of America image

In design mode right click on the "Type" text box, select Properties. Under the Data tab, look at the Control Source. Make sure it is the same field that contains the instructions. Take into account any other tables that may be related to your query.

Flyster
If MX's theory is correct, then this is the reason why most developers *Do Not* use lookup fields in the table.
See here:
http://access.mvps.org/access/lookupfields.htm
Using them in Forms is fine, though...

The other Experts here can outline the techniques to display the Text value instead.

JeffCoachman
Avatar of shart68
shart68

ASKER

Yes MX - it does look like the example.  What do I need to do to fix this?  Bear in mind that I do have a form where I need to use that lookup in order to display the proper value in the subform.
"where I need to use that lookup in order"
Actually, the greatly preferred way is simply to create that 'lookup' on the Form using a Combo box.
The fix is to eliminate ALL of those combos at the table level, as you can see the kind of confusion they lead to.

mx
Avatar of shart68
shart68

ASKER

OK - I removed all the lookup from the table and set the lookup on the form so that is correct.  But I cannot get it to display the value on the report.  And the underlying query shows the ID rather than the value as well.  how can I change it on the query so it displays the value?
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Has this question been resolved?  Can we close the question ?

thx.mx
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo