List Box showing the wrong values.

[David Ball]

Hi,
I have a table, tblLocations, that contains various place names. In this table I have a unique ID for each location that is an Autonumber Data Type.
There is another table, tblLocationDetails, where the Location is used to provide the place name of a place (town, city, etc). In the second table the Location comes from the first table via a Lookup in the Data Type column, so that I can use a List Box on a form to select the locations.
I now want to set up a List Box on another form where I can select a location and then run a report to see details of the location.
The problem I have is that when I set up the List Box, using tblLocationDetails as the source table, I get numbers (the Autonumber values from the first table) instead of the location names in my list box.
I don’t want to use tblLocations for this List Box because it will show me all locations in this table and they may not have been selected to appear in tblLocationDetails. I only want my users to have the option of selecting locations that are in tblLocationDetails.
How can I get the location names to appear in the List Box rather than the autonumbers?
Thanks very much
Dave

 

[isladogs]

Use a query which includes both tables as the row source for your listbox. Select the columns you need. Include the field used to link the tables as the first bound column and set its width to zero so it's hidden

 

[David Ball]

Thanks very much, ridders