Table now showing id instead of text

[spoolinaz]

I've created a "table" with all my cases which includes date, hospital, surgeon, etc. The hospital and surgeon column have always shown the actual name in text (dropdown) and now all of a sudden, it's just showing the ID only. Now when I go to add a new case, I have to know the number instead of the dropdown just working and being able to select a hospital name, etc. I'm not sure how to get it back to showing the actual name instead of the id number associated with it. I think I might have messed it up by removing some relationships by accident. I've not worked with Access in 20 years so just struggling. Any help would be greatly appreciated.

[ItsMe]

... I'm not sure how to get it back to showing the actual name instead of the id number associated with it...

It sounds as though you are using a lookup field in your table. If this is the case and you changed the values in the properties of your lookup field, I am not sure how you would get it back to showing the names either. Perhaps you can look at historical data and reconstruct the lookup.

If you are not using lookup fields, perhaps you can elaborate where this dropdown is located and what its RowSource is.

[Demerit]

From your explanation, it actually shows you are using a lookup Just like ItsMe said. In this "table" that you created, lets illustrate from the Hospital field then you can use that to correct the other.

1. Go back to the design view of the table.
2. Select the Hospital field
3. In the Lookup property, (In the row source, assuming Id comes first and HospitalName comes second otherwise you can set it like that)
4. In the Bound Column enter 2 (by default, it is 1)
5. In the column width, enter 0";1"

then write back if you have a problem.

[Demerit]

Note that of you can as well do this on a form.

[spoolinaz]

Thank you both very much. This was very helpful and I was able to get those back. Whew!

I'm now getting this new error that you might be able to assist with.

Microsoft Access can't set the LimitToList property to No right now.
The first visible column, which is determined by the ColumnWidths property, isn't equal to the bound column.
Adjust the ColumnWidths property first, and then set the LimitToList property.

I've played around with this so much I'm sure I screwed it up along the way and just not able to solve it. Suggestions!

[ItsMe]

Are you referring to a combobox on a form? You need to adjust the properties of comboboxes in a way they select, display, and bind the correct columns.