List Box displayin ID instead of the actual value

[Yiipie]

Hi all,

First time posting, I was hoping for a little help. So far I've managed to develope a database system with functioning forms. However I'm now in the process of altering specific factors before I continue to add the data into the system (Theres a lot to add).



I've followed some advise from other threads in the forum and only used queries to alter my data within my tables. However I've stumbled accross an issue that i can't find a work around for.

I have a query 'Proc - Browse Query', this pulls all the data from my 'Proc - Add Query' which in turn links to my three tables 'BS - Master List', 'Procedure - Master List' and 'Procedure - Update Log'.

There are additional tables that create the entire system, however these are the ones linked to my current issue.

I have a form called 'Proc - View' that shows a list box of all the data from the 'Proc - Browse Query', however one column is showing the ID of the item not the title that i wish it to display.

I've hidden all unneccasary tables, forms, queries etc. The ones relevant are unhidden within the attached zip folder.

Cardinal ERP System.zip

I apologise if the system is hard to follow, this is my first time utilising access properly in over 10 years.

[CJ_London]

however one column is showing the ID of the item not the title that i wish it to display.

which column?

[Yiipie]

Hi Ajax,

In the 'Proc - Browse Query' its the column titled 'British Standard Link' and on the form 'Proc - View' Its column 3 with the 'British Standard(s)' text above. My issue is that the column comes from a Multiple Value Lookup Selection field, No matter what i've tried, it won't display the selections as 'ISO 14001, ISO 18001' even though its shown as such in the Query, instead it shows the ID of these items.

[CJ_London]

that is one of the problems with multivalue fields used in situations like this - you have no control over what is displayed.

Create a new query based on the rowsource to your listbox.

Then create a datasheet form on the query by selecting the query then clicking on the more forms option on the ribbon and selecting datasheet. You may need to edit the labels to display the column headers you want. Also probably disable things like Navigation buttons

then use this form as a subform instead of your listbox

[Yiipie]

Thanks Ajax, I've been trying to find a solution for several hours now and its only resulted in being back to sqaure one. I'll see if i can implement your advised method now. Appreciate the time.

[Yiipie]

Thank you!!!

Worked a treat, however i can't seem to be able to relable the headers. Is there any way to disable them so they don't show? I know this is a backwards way of working, however once this systems in place it won't be getting altered or changed. (Lets say the the staff within the company aren't as knowledgable on anything technical.

[CJ_London]

no way to disable the headers in a datasheet, but there are ways to rename them

1. to relabel, go into the form design view, click on the label and put what you there - or go to the label properties and change it in the caption

2. alternatively in your query use something like

name you want:name of field

3. or use a continuous form (also known as a multiple item form)- labels are then in the header so you can change there instead, or you can delete them. You can format a continuous form to look like a datasheet/listbox by repositioning controls

4. You can also use the caption property in your underlying tables or the query