Field displays number instead of value

[rdueck]

Hi There, I know this may not seem difficult, but it's driving me crazy. I have a report based on a query. There's a field in the form that uses a lookup wizard which grabs a list from another table (a list of names)

When I created and ran the query it displays the names. But when I run the report based on that query, it shows a number instead of the name.

I'm grouping the report by name. How can I get the report to show the name instead of a number?



Thanks for your help... Randy

I understand it's the grouping that's killing me here. If I don't group by Name, it displays the name. If I do group by name it shows a number.

[SoftwareMatters]

I'm not sure about the grouping side of things but you probably need to change the field from a text box to a combo box. Or link the table in the query and bring the name field straight through to the report.

[RuralGuy]

You're not using a Lookup Field are you?

[Karend440]

Just curious, same issue I am having. Is there an alternate method to using a Lookup Field? (ComboBox) I notice the same thing, when you select an item from the list, it is storing the "ID" field, and not the actual selection name from the list.

[RuralGuy]

You *want* to store the "ID" rather than the "text". You can always retrieve the "text" with a join in a query if you want to display it. ComboBoxes on forms is the right way to go, just not at the table level.

[Karend440]

Thanks!
I just have someone who just keeps using the tables instead of the forms, so I was curious to know if i was doing something wrong. He just doesn't want to look at an ID number instead of a real part number in the table. Appreciate the response!

[RuralGuy]

I don't let my users see the tables. They are forced to only use the forms I have provided.