I have a list box that is based on a query. This query is based on two other queries and two tables.

The problem is my list box does not display the actual name value of my two LookUp fields, they show the value number instead (1 is Tom, 2 is Mark, 3 is Nany). The query that the list box is based on does (Shows Tom instead of 1).

Any one has any suggestions?

Thanks in advance!

If the Row Source Query for the listbox contains 2 fields, then in the property list for the listbox, set the Column Count to 2, the Bound Column to 1, the Column Widths to 0";1" (you may need to adjust the second entry to fit).

This should make the listbox react the way you want.

HTH
RDH

Thanks for the reply. Sorry I forgot to mention that all other columns from my List Box display fine.

My Column Count is 6. Two of the six columns display the value number instead of the value name. The type of Field is LookUp.

Thanks!

What you are displaying is the foriegn key value from the related tables. You need to include the needed tables in the Row Source Query, then get the values needed from these related tables.

This more than likely confused you more than helped. If the db is wriiten in Access 97, I will be glad to fix the problem for you. Just email it to me with the info about the where you want it done.

HTH
RDH

I don't understand. It's is on the Row Source.

Row Source from my List Box:
****************************************
SELECT [OpenItems].[Work Order No], [OpenItems].[User Name], [OpenItems].[Assigned To ID], [OpenItems].[Status Categories ID], [OpenItems].[Date], [OpenItems].[Promised Date] FROM OpenItems;
*******************************************
I have Access 2000 but can converted to prior version.

I'll email it to you tomorrow. Thanks for the offer.

You are going to get the numbers you refer to in the third and forth columns. These fields are the ones that have to be from the related tables mentioned in the earlier post.

If you don't figure it out, send it to me when you get a chance.

RDH

Thanks! It works.

But, (sorry there is but!). How do I get it to display the changes in the two LookUp fields. What ever that was selected the first time, they kept original value. Sounds like I have to Requery? How?

Thanks R.Hicks for getting me this far. Any suggestion on this one? http://www.access-programmers.co.uk/ubb/smile.gif

Neo


[This message has been edited by Neo90815 (edited 10-06-2000).]

[This message has been edited by Neo90815 (edited 10-06-2000).]