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.
Example in the report:
doc number description rev type
123 test doc A 1 (type should be Instructions)
thanks.
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
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
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
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Has this question been resolved? Can we close the question ?
thx.mx
thx.mx
mx
Capture1.gif